ISEVEN function
ISEVEN returns TRUE if a number is even and FALSE if it is odd. It is handy for alternating rows, and text input returns #VALUE!.
Example
Read it as a sentence: check whether 4 is an even number, which gives TRUE.
A
B
C
D
1
TRUE
2
3
Syntax
ISEVEN(number)
-
number(required) - The number to test.
Returns: TRUE for an even number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISEVEN(2) | TRUE | Even |
=ISEVEN(3) | FALSE | Odd |
=ISEVEN(2.9) | TRUE | Fractional |
=ISEVEN(-2) | TRUE | Negative |
=ISEVEN(0) | TRUE | Zero |
=ISEVEN("4") | TRUE | Text number |
=ISEVEN("a") | #VALUE! | Text |
=ISEVEN(TRUE) | #VALUE! | Bool literal |
Watch out for
- Decimals are truncated before testing.
- Text returns #VALUE!.
Where it works
- Excel
- ISEVEN is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .