"Eduardo" wrote:
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 -----

"Eduardo" wrote:
Hi,
take a look to the Microsoft help, function ISODD

Returns TRUE if number is odd, or FALSE if number is even.

Syntax

ISODD(number)



"petedacook" wrote:

Is there a function to determine if a cell has odd or even numbers? This
would be used in an "IF" statement.

Thanks,

pete K