Syntax
ISEVEN(number)
| Parameter | Description |
|---|---|
| number | Parameter of the ISEVEN function. |
Examples
Check even number
Formula
=ISEVEN(4)
Returns TRUE because 4 is divisible by 2.
Alternating formatting
Formula
=ISEVEN(ROW())
Returns TRUE for even-numbered rows. Use as a conditional formatting rule to create alternating row colors (zebra stripes).
Process even items
Formula
=IF(ISEVEN(A1), A1/2, A1)
Halves even numbers but leaves odd numbers unchanged. If A1=8, returns 4. If A1=7, returns 7.
Common Errors
#VALUE!
Occurs when the argument is non-numeric text like "hello". Text that looks like a number ("4") may be auto-converted in some apps.
Tips
Zero is even
ISEVEN(0) returns TRUE. Zero is mathematically even (divisible by 2 with no remainder).
Decimals are truncated
ISEVEN(3.9) returns FALSE because 3.9 is truncated to 3, which is odd. The function checks the integer part only.
Alternative: MOD
=MOD(A1,2)=0 does the same thing as ISEVEN(A1). MOD is more flexible for checking divisibility by other numbers (3, 5, etc.).
Try ISEVEN in Viztab
Import your data and use ISEVEN with 370+ other formulas. No signup required.
Open Viztab