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:


Any help?

Tom Urtis