What is the Excel ISODD Function?
The ISODD function is a function to check whether a number is odd or not, returns TRUE if the number is odd and FALSE if not.
number, required, the numeric value to test
- If the numeric value to test is not an integer number, then Excel truncates the decimal fraction
- If the numeric value to test is not a number, then Excel returns a #VALUE! Error.
How to Use ISODD Function in Excel
For example, there is data like the image below. What is the result of the ISODD function in column B?
ISODD Function #1
The result is FALSE; it turns out that 0 is an even number. Why? Even numbers are numbers that do not produce a remainder if divided by 2; number 0 fulfills this requirement.
ISODD Function #2
The result is TRUE. The number 1.25 is considered an odd number. Excel considers 1.25 as 1, Excel truncates the decimal fraction and process the integer number only.
ISODD Function #3
The result is FALSE. Negative signs do not affect an odd/even number. Number 2 is an even number, positive or negative.
ISODD Function #4
The result is TRUE. -3.99 is the negative decimal number whose value is closer to round up. Excel does not see whether the decimal number is closer rounded up or down. All decimal fractions will be truncated.
So, the number -3.99 is considered a number -3, an odd number.
ISODD Function #5
The result is FALSE. Number 4 is an even number, no remainder if divided by the number 2.
ISODD Function #6
“Number” 5,75, at a glance like a number, but is text, because decimal separators use a comma, should use a period. The result is a #VALUE error!
Please see the image below for the results of the six functions above