ISODD

Formulas / ISODD
Test whether a value is odd.
=ISODD(number)
  • number - the value to test

Examples

  • =ISODD(2)

    This returns FALSE because 2 is an even number.

  • =ISODD(9)

    This returns TRUE because 9 is an odd number.

  • =ISODD(A2)

    This returns TRUE because A2 contains 15.

  • =ISODD(B2)

    This returns FALSE because B2 contains 8.

  • =ISODD(-7)

    This returns TRUE because -7 is an odd number.


Summary

The ISODD function is used to determine if a number is odd or even. It returns TRUE if the number is odd and FALSE if the number is even.

  • The ISODD function is used to determine whether a value is odd or even. It returns TRUE if the value is odd, and FALSE if the value is even.

Frequently Asked Questions

What is the ISODD function?
The ISODD function is a boolean function that returns a TRUE or FALSE value depending on whether the input number is odd or even.
What does the ISODD function return if the input number is odd?
The ISODD function returns TRUE if the input number is odd.
What does the ISODD function return if the input number is even?
The ISODD function returns FALSE if the input number is even.
What does the ISODD function return if the input number is not numeric?
The ISODD function returns the #VALUE! error if the input number is not numeric.
What are some examples of numbers that the ISODD function returns TRUE for?
  • 3
  • 5
  • 7
  • 9
What are some examples of numbers that the ISODD function returns FALSE for?
  • 2
  • 4
  • 6
  • 8

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV