ISEVEN

Excel Functions

Test if a value is even

Syntax

EXCEL

=ISEVEN(value)

Arguments

Parameter	Description
`value`	The numeric value to check.

Return Value

A logical value (TRUE or FALSE)

Details

The ISEVEN function tests for even numbers. ISEVEN takes one argument, value, which should be a numeric value or a cell reference. When value is an even number, ISEVEN returns TRUE. When value is an odd number, ISEVEN returns FALSE. If value is not numeric, ISEVEN will return the #VALUE error. Only the integer portion of value is evaluated, decimal values are truncated. The ISEVEN function returns TRUE or FALSE: If cell A1 contains 11, the formula below returns FALSE: Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:

Examples

The ISEVEN function returns TRUE or FALSE:

EXCEL

=ISEVEN(4) // returns TRUE
=ISEVEN(3) // returns FALSE
=ISEVEN(0) // returns TRUE

Examples

If cell A1 contains 11, the formula below returns FALSE:

EXCEL

=ISEVEN(A1) //returns FALSE

Examples

Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:

EXCEL

=ISEVEN(4.1) // returns TRUE
=ISEVEN(0.33) // returns TRUE
=ISEVEN(7.4) // returns FALSE

ISEVEN

Syntax

Arguments

Return Value

Details

Examples

See Also