Multiples of a Number

[leesanc]

I am trying to write an If statement in Excel to return an "OK" if Value 1 - Value 2 = Multiples of 2 (i.e. 2,4,6,8,10,12 ....)

Is there any formula for "multiples of a specific number

 

[Molby]

How about:

=IF(MOD((Value1-Value2),2)=0,"OK","FALSE")

Where the 2 is the mutiple you want to check.

 

[leesanc]

Wow! So fast.

Yes, it works! Thank you so much.

 

[GlennUK]

Or:

=IF(ISEVEN(Value1-Value2),"OK","FALSE")

if the multiple is always 2. ( tests for an even result. See the ISODD function for comparison. )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[leesanc]

The multiple can be any other number, but this would come in handy too. Thank you.