Excel: Worksheet Function to Determine if Integer Even or OddLast reviewed: November 2, 1994Article ID: Q61274 |
The information in this article applies to:
SUMMARYThe following is a worksheet formula to determine whether an integer in cell A1 is even:
=IF(MOD(A1,2)=0,"even","odd")Note that if cell A1 is empty, this formula will return "even". If A1 contains a text value, a #VALUE! error will be returned.
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |