Excel ISODD Function

Using the Excel ISODD Function


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


=ISODD (number)

Syntax Breakdown

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.