Excel Functions

Excel ISODD Function

Pinterest LinkedIn Tumblr

The Excel ISODD function tests whether a numeric value is odd. This function returns TRUE when a numeric value is odd and FALSE when even. It returns #VALUE! error when the value is non-numeric.

Purpose of Excel ISODD Function

To test whether a numeric value is odd.

Return value

This function returns TRUE or FALSE.


= ISODD(number)


numberThe value to test.Mandatory

Usage notes

  • This function check if a numeric value is an odd number.
  • This function is the opposite of the ISEVEN function.
  • If the number is not an integer, it is truncated.
  • #VALUE! error – This occurs when the given argument is non-numeric.


Since 2007 for Windows.

Since 2011 for Mac.

Related Posts

Write A Comment