Microsoft® Excel® 2010 Formulas & Functions Inside Out

ISEVEN()

Note

In Excel 2003, this function is available as an add-in.

Syntax. ISEVEN(number)

Definition. This function returns TRUE if the number argument is an even number. If the argument is an odd number, the function returns FALSE.

Arguments

• number (required). The expression to be checked

Background. You can pass any expression as an argument to this function. Integers are treated as expected. If you pass a decimal number, the decimal places are truncated and the resulting value is evaluated. =ISEVEN(2.4) returns TRUE, and =ISEVEN(-1.6) returns FALSE.

If the argument cannot be evaluated, the function returns the #VALUE! error for strings and logical values.

The ISEVEN() function is the counterpart to the ISODD() function:

ISEVEN(number)=NOT(ISODD(number)) ...