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

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

"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

=CHOOSE(ISODD(A1)+1,"even","odd")


"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

You should also be able to protect against the MOD bug by simply looking at
the last digit (which is a range of digits that MOD has no trouble with)...

=IF(MOD(RIGHT(B3),2),"Odd","Even")

--
Rick (MVP - Excel)


"Joe User" <joeu2004 wrote in message
...
"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