How to Check Whether a Value is an Even Number

The ISEVEN Function checks whether a value is an even number. When it is an even number, the result returns to "TRUE", and returns "FALSE" when it is not an even number.


= ISEVEN(value)


Value is required, the result returns TRUE when the value is an even number or returns False when it is not an even number.


When the value is TEXT, the result returns #VALUE! error.


Cell A2 is number 1 which is an odd number, ISEVEN(A2) returns to False.


Cell A3 is number 2 which is an even number, ISEVEN(A3) returns to True.

Download ISEVEN Function

Leave a Reply