Returns a Boolean value (TRUE or FALSE) which determine whether a number an even number (divisible by 2) or not.

TRUE means the number is an even number, and vice versa.



Number - the number to be considered.


ISEVEN(2000) returns TRUE
ISEVEN(2001) returns FALSE


The ISEVEN function can analysis number input in the range:
- 2,147,483,648 < Number < 2,147,483,648

If a non-whole number is input into the function, for example 14.5, the integral part will be considered:

ISEVEN(14.5) returns TRUE , because the function considers the integral part, which is 14.

If a non-numeric value is input into the function, it will return an error:

ISEVEN(“abc”) returns “#VALUE!”.