Checks whether a value is odd and returns TRUE or FALSE.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
ISODD(number)The ISODD function evaluates a numeric value and returns TRUE if the number is odd, or FALSE if it is even. If the provided argument is not an integer, it is truncated toward zero before the check is performed.
=ISODD(3)Result: TRUE
3 is an odd number.
=ISODD(4.5)Result: FALSE
4.5 is truncated to 4, which is an even number.
The function will return a #VALUE! error if the input cannot be converted to a number.