ISODD

ISODD(number)

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

numberThe 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.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top