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!”.