EXCEL ISEVEN FUNCTION

This function checks whether a numeric value is an even integer and returns TRUE if it is, else FALSE. ISEVEN will return the #VALUE error if value is not a number.

Syntax:

=ISEVEN (value)
Parameter:

  • Value is usually specified as a cell address, such as =ISEVEN (A1)
    TRUE will be returned by =ISEVER(2).
    FALSE will be returned by =ISEVER(1).

Step By Step Guide of ISEVEN Function

Example:

If value is an even integer or a reference to a cell holding an even integer, ISEVEN returns TRUE, otherwise FALSE.

  • In conditional statements, this function is most commonly used in combination with IF.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now