Forum Discussion
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
Number formatting will display the words "Odd" and "Even" leaving the formula as
= MOD(number, 2)
That's a great trick, I totally forget about it. Quite seldom used on practice.
Hi there,
Please follow the attached file.
However, you may write the following formula:
=IF(ISEVEN(A3)=FALSE, "Odd", "Even")
