Buzz
The following article introduces you to the ISODD function – one of the functions highly favored in the information group in Excel.
Description: Returns True if the value is odd. Apply the function to check for odd and even numbers.
Syntax: ISODD(number)
In which:
- number: The value to be checked if it is odd or not, is a required parameter.
Note:
- The function returns True if the value is odd, otherwise, it returns False.
- If value is empty, the function treats it as 0 and returns False.
- If value is not a numerical value, the function returns an error value #VALUE!
Example:
Determine if the values in value are odd or not?
- In the cell where calculation is needed, input the formula: =ISODD(C6)
- Press Enter -> the returned value is:
- Similarly, copy the formula for the remaining values to obtain the result:
- If value is empty, the function returns the value False:
- If value is not a numerical value, the function returns an error value #VALUE!
Here is the guide and some specific examples when using the ISODD function in Excel.
Wishing you all the best!
