Microsoft Excel Functions & Formulas

Use the ISEVEN and ISODD functions to check if

a number is even or odd

To find out whether numbers are even or odd, use the ISEVEN or

ISODD functions. ISEVEN returns TRUE if the number is even

and FALSE if the number is odd, while ISODD returns TRUE if the

number is odd and FALSE if the number is even.

ISEVEN(number)

ISODD(number)

number: The value to be tested. Non-integer values are

truncated.

4

To check if a number is even or odd:

1. In cells A2:A10 enter some numbers.

2. Select cells B2:B10 and type the following formula:

=IF(ISEVEN(A2),"X","").

3. Press <Ctrl+Enter>.

4. Select cell C2:C10 and type the following formula:

=IF(ISODD(A2),"X","").

5. Press