Site icon ExcelNotes

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.

Formula:

= ISODD(value)

Explanations:

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

Cautions:

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

=ISODD(A2)

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

=ISEVEN(A3)

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

Download ISODD Function

Exit mobile version