Excel ISODD Function

Using the Excel ISODD Function

Excel ISODD Function

Summary

The Excel ISODD function returns TRUE when a number is odd, and FALSE when it is not.

Syntax

=ISODD (number)

Syntax Breakdown

Number
Required. A value that will be tested to determine if it is odd or even. Typically supplied as a cell address.

Usage Notes

ISODD will check if a number is odd or even. If the number is odd the function returns TRUE. If even, the function returns FALSE.

If the number argument is non-numeric, the function returns the #VALUE! error.