P
petedacook
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
would be used in an "IF" statement.
Thanks,
pete K
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
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)
take a look to the Microsoft help, function ISODD
Returns TRUE if number is odd, or FALSE if number is even.
Syntax
ISODD(number)
J
Joe User
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 -----
T
Teethless mama
=CHOOSE(ISODD(A1)+1,"even","odd")
R
Rick Rothstein
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")
the last digit (which is a range of digits that MOD has no trouble with)...
=IF(MOD(RIGHT(B3),2),"Odd","Even")