How to use ISODD Function in Excel

The Excel ISODD function returns TRUE when a numeric value is odd, and FALSE for even numbers. ISODD will return the #VALUE error when a value is not numeric.

Syntax:= ISODD (value)

The ISODD function syntax has the following arguments:

  • Required. The value to test. If number is not an integer, it is truncated.

Example: Let’s look at some Excel ISODD function examples and explore how to use the ISODD function as a worksheet function in Microsoft Excel:

Syntax:  =ISODD(A2)


Based on the Excel spreadsheet above, the following ISODD examples would return:

Syntax: =ISODD(A3)
Result: TRUE

Syntax: =ISODD(A4)
Result: FALSE

Syntax: =ISODD(A5)
Result: FALSE

Syntax: =ISODD(A6)
Result: FALSE

Syntax: =ISODD(A7)
Result: FALSE

Syntax: =ISODD(A8)
Result: #VALUE!

Syntax: =ISODD(A9)
Result: #VALUE!


  1. #VALUE! error – Occurs when the given argument is non-numeric.
  2. We can insert a reference to a cell as seen in the examples above, or a number directly in double quotes to get the desired result.
  3. The ISODD function was introduced in Excel 2007 and, hence, is unavailable in earlier versions. It will return an error if used in earlier versions. For older versions, we can use the MOD function.
  4. ISODD is the opposite of the ISEVEN function.

Add a Comment

Your email address will not be published. Required fields are marked *