# The Excel ISEVEN Function

Related Functions:
ISNUMBER
ISODD

## 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.