How to Check Whether a Value is an Odd Number

The ISODD Function checks whether a value is an odd number. When it is an odd number, the result returns to "TRUE", and returns "FALSE" when it is not an odd number.


= ISODD(value)


Value is required, the result returns TRUE when the value is an odd number or returns False when it is not an odd number.


When the value is TEXT, the result returns #VALUE! error.


Cell A2 is number 1 which is an odd number, ISODD(A2) returns to True.


Cell A3 is number 2 which is an even number, ISODD(A3) returns to False.

Download ISODD Function

Leave a Reply