Function for odd even numbers

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
 
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)
 
J

Joe User

Eduardo said:
take a look to the Microsoft help, function ISODD
Click to expand...

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 -----
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd and even header and footers with section break 2
(headers & footers Issue) I have 2 even pages back to back!! 1
Publisher adding blank page when printing my booklet... 2
Cumulative formula for word table 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Odd and even numbers 6
How can the font and size of (all) citation numbers be altered? 1
Template with fields and premade texts.. 0

Top