Multiples of 4 in an IF statement
 

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

Multiples of 4 in an IF statement
 

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

Multiples of 4 in an IF statement
 

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

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

Multiples of 4 in an IF statement
 

Worked perfect! Thanks!


--
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