MrExcel Publishing
Your One Stop for Excel Tips & Solutions

odd/even formula


Posted by Chris on January 07, 2002 7:45 PM

Could someone please give me a formula for determining if a number is odd or even?


Posted by Tom Urtis on January 07, 2002 8:29 PM

Assuming the number you want to evaluate is in cell A1, enter this formula in the cell of your choice:

=IF(MOD(A1,2)=0,"Even","Odd")

Any help?

Tom Urtis