if formula
 

i have a column, i have to generate a formula usinfg a if statement that if
its divisable by 3 than it should be true otherwise false

if formula
 

=MOD(A1,3)=0

--

HTH

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


"zomex" wrote in message
...
i have a column, i have to generate a formula usinfg a if statement that
if
its divisable by 3 than it should be true otherwise false

if formula
 

"zomex" wrote:
i have a column, i have to generate a formula usinfg
a if statement that if its divisable by 3 than it should
be true otherwise false

If your class assignment requires an IF() function, then:

=IF(MOD(A1,3)=0,TRUE,FALSE)