# 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:
AB
1=ISEVEN( 0 )
2=ISEVEN( 1 )
3=ISEVEN( 2 )
4=ISEVEN( 20/4 )
5=ISEVEN( B5 )10
6=ISEVEN( B6 )
Results:
AB
1TRUE
2FALSE
3TRUE
4FALSE
5TRUE10
6TRUE

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.