Eduardo said:
take a look to the Microsoft help, function ISODD
Good answer. That would be my choice.
But if you do not want to rely on the ATP (Excel 2003 and earlier), you
might try the following:
=IF(MOD(A1,2), "odd", "even")
There are bugs in MOD. For example, try MOD(123456789012345,2). So it
might be prudent to use this alternative:
=IF(INT(A1/2)*2 <> A1, "odd", "even")
----- original message -----