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.
The syntax of the function is:
Where the supplied number argument is the value or expression to be tested.
Several examples of the Excel Iseven function are shown in the spreadsheets below:
Note that the example in cell A1 shows that the Iseven function returns True for a zero value. Also, as seen in cell A6, an empty cell evaluates to zero and so the Iseven function also returns True in this case.
Further information and examples of the Excel 'Is' functions are provided on the Microsoft Office website.
If you get an error from the Excel Iseven function this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if the supplied number argument is not a numeric value.|