if
 

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

if
 

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

--
Ian
--
"zomex" wrote in message
...
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

if
 

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

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


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=491391

if
 

see response in other thread

--

HTH

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


"zomex" wrote in message
...
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