The Excel ISEVEN Function

Related Functions:

Function Description

The Excel Iseven function tests if a supplied number (or numeric expression) evaluates to an even number, and if so, returns TRUE; Otherwise, the function returns FALSE.

The syntax of the function is:

ISEVEN( number )

Where the supplied number argument is the value or expression to be tested.

Iseven Function Examples

The following spreadsheet shows six examples of the Excel Iseven function:

Formulas:

	A	B
1	=ISEVEN( 0 )
2	=ISEVEN( 1 )
3	=ISEVEN( 2 )
4	=ISEVEN( 20/4 )
5	=ISEVEN( B5 )	10
6	=ISEVEN( B6 )

Results:

	A	B
1	TRUE
2	FALSE
3	TRUE
4	FALSE
5	TRUE	10
6	TRUE

Note that in the above example spreadsheet:

The example in cell A1 shows that the Iseven function returns True for a zero value;
The Iseven function evaluates empty cells to zero and so returns True if supplied with a reference to an empty cell (see cell A6).

For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.

Iseven Function Error

If you get an error from the Excel Iseven function this is likely to be the #VALUE! error:

Common Error

#VALUE!

Occurs if the supplied number argument is non-numeric.

Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions