Excel - Determine if a number IS Odd or Even

[gshock]

Trying to find a way to validate a number by determining whether the number is odd or even (a true or false argument).

Help is kindly appreciated.

Thanks.

 

[bluedragon2]

if number/2 = integer of number /2

=A1/2=INT(A1/2)



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[KenWright]

With your data in A1

=ISODD(A1)

or

=ISEVEN(A1)

This will give you the TRUE/FALSE result. (May well be part of the Analysis Toolpak addin though (Not sure to be honest)

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------