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.

Formula:

= ISEVEN(value)

Explanations:

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

Cautions:

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

=ISEVEN(A2)

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

=ISEVEN(A3)

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

Download ISEVEN Function

Leave a Reply