Multiples of 4 in an IF statement

[Barry Clark]

Hello all.

I have an IF statement in one of my cells.


Code
-------------------
=IF(logical_test,value_if_true,value_if_false
-------------------


In the logical_test portion, would like to have the cell evaluated fo
multiples of 4.

Code

 

[David Billigmeier]

use MOD()...


=IF(MOD(A1,4)=0,value_if_true,value_if_false)

 

[Peo Sjoblom]

Do you mean like this?

=IF(MOD(A1,4)=0,"a","b")


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Barry Clark" <[email protected]>
wrote in message
news:[email protected]...

 

[Barry Clark]

Worked perfect! Thanks