# Odd / Even Numbers

Occasional Contributor

# Odd / Even Numbers

I am trying to figure out a formula where you can reference a cell and if the number in the cell is an odd one it would put the word odd in the current cell and if it is even the same thing.  I was trying

=if(b5=odd,"Odd","Even")

But I can't seem to get it working.  Is it possible?  I simply was to have the cell I am working in look at another cell and tell

5 Replies

# Re: Odd / Even Numbers

@Larry1921 try =if(ISODD(b5),"Odd","Even")

# Re: Odd / Even Numbers

@Larry1921 , another alternative would be:

``````=IF(MOD(B5,2),
"Odd","Even")``````

# Re: Odd / Even Numbers

@Larry1921

Hi there,

However, you may write the following formula:

=IF(ISEVEN(A3)=FALSE, "Odd", "Even")

# Re: Odd / Even Numbers

Number formatting will display the words "Odd" and "Even" leaving the formula as

= MOD(number, 2)

# Re: Odd / Even Numbers

That's a great trick, I totally forget about it. Quite seldom used on practice.