Odd / Even Numbers

[Larry1921]

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 

[#2]

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

[#3]

@Larry1921 , another alternative would be: 

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

[#4]

@Larry1921

Hi there,

Please follow the attached file.

However, you may write the following formula:

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

[#5]

@Larry1921 

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

= MOD(number, 2)

[#6]

@Peter Bartholomew 

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