Skip to main content

ISODD

The ISODD function checks if the value is an odd number.

Returns TRUE if it is and FALSE if not.

This can be useful when you need to analyze data and select only even values.

Syntax​

ISODD(value)

ArgumentDescriptionPermitted values
valueNumber that is checked whether it belongs to odd numbersAny number. Can be specified as a number, formula, function, or cell reference

Examples of use​

Checking whether the number 7 is odd:

=ISODD(7)

Result: TRUE.

Checking whether the number 10 is odd:

=ISODD(10)

Result: FALSE.

Checking whether the number in cell A1 is odd:

=ISODD(A1)

Result: TRUE or FALSE depending on the value in cell A1.

Notes​

  • If the argument is not a numerical value, the function will return the #VALUE! error.
  • If the number is not an integer, it is rounded to the nearest integer before being checked.
  • For negative numbers, parity or oddness is also determined.
  • To check for parity, use the ISEVEN function.