use MOD()...
=IF(MOD(A1,4)=0,value_if_true,value_if_false)
--
Regards,
Dave
"Barry Clark" wrote:
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 for
multiples of 4.
Code:
--------------------
=IF(A1=(multiples of 4),value_if_true,value_if_false)
--------------------
Anyone know of a way to pull this off?
--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=573911