Microsoft® Excel® 2010 Formulas & Functions Inside Out

ISODD()

Note

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

Syntax. ISODD(number)

Definition. This function returns TRUE if the number argument is an odd number. If the argument is an even 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. =ISODD(2.4) returns FALSE, and =ISODD(-1.6) returns TRUE.

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

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

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

Example. You can use the example for the ...