ISEVEN

This function, Is Number Even, tests whether a value, an expression or contents of a referenced cell is even.

Syntax

ISEVEN(cellreference)

ISEVEN(value)

ISEVEN(expression)

Arguments

Specify a cell reference, a numeric or text value, or an expression for the argument.

Remarks

• If the number specified by the argument is even, the function returns TRUE.

• If the number specified by the argument is odd, the function returns FALSE.

• If the number specified by the argument is zero, the function returns TRUE.

• If the number specified by the argument refers to an empty cell or no data, the function returns TRUE.

Use this function to test the contents of a cell, a numeric or text value directly, or a function or expression.

Data Types

Accepts numeric data. Returns Boolean (TRUE or FALSE) data.

Examples

ISEVEN(B3)

ISEVEN(R1C2)

ISEVEN(574) gives the result TRUE

ISEVEN(9) gives the result FALSE

ISEVEN(2.4) gives the result TRUE

ISEVEN(3.6) gives the result FALSE

ISEVEN(ROUND(3.6)) gives the result TRUE