if

[zomex]

i have numbers in a column from c4:c24, i have to apply a condition that has
two outputs...if its divisable by 3 than it should be true other wise it
should be false

 

[Ian]

=IF(C4/3=INT(C4/3),"True","False") and copy down the column.

 

[tony h]

try
=if(int(c4)/3=c4/3,true,false)

or simply
=int(c4)/3=c4/3

 

[Bob Phillips]

see response in other thread

--

HTH

RP
(remove nothere from the email address if mailing direct)