Home » Excel-Built-In-Functions » Excel-Iseven-Function

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

If the value provided to the function is not a number, the function returns the #VALUE! error.

The format of the ISEVEN function is :

Where the number argument can be a simple number, a formula or a cell reference.

Examples

The spreadsheets below show examples of the Excel ISEVEN function. The spreadsheet on the left shows the formulas used and the spreadsheet on the right shows the results :

Note that the examples in cells A1 and A5 above show that the ISEVEN function returns True for a zero, or an empty cell.