ISODD

ISODD(number)

Returns the boolean True or False depending if the value is an odd number.

number

The number you want to test.

REMARKS

* If "number" is not an integer, it is truncated.
* If "number" is not numeric, then #VALUE! is returned.
* Any numbers enclosed in double quotation marks are converted to numbers.
* You can use the ISEVEN function to return True or False depending if the value is an even number.
* You can use the ISNUMBER function it return True or False depending if the value is a number.
* You can use the ODD function to return the number rounded to the nearest odd integer.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=ISODD(3.5) = True
2	=ISODD("3") = True
3	=ISODD(0) = False
4	=ISODD(-1) = True
5	=ISODD(6) = False
6	=ISODD(26) = False
7	=ISODD("some text") = #VALUE!

1 - Is the number 3.5 an odd number. This decimal number will be truncated to 3.
2 - Is the text string "3" an odd number. This is converted to a number.
3 - Is the text string "0" an odd number. This is converted to a number.
4 - Is the number -1 an odd number.
5 - Is the number 5 an odd number.
6 - Is the number 23 an odd number.
7 - Is the text string "some text" an odd number.