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 t...
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.