Multiples of 4 in an IF statement

[Barry Clark]

Hello all.

I have an IF statement in one of my cells.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Anyone know of a way to pull this off?

[David Billigmeier]

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

[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]...
>
> 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
>

[Barry Clark]

Worked perfect! Thanks!