ISODD

Returns TRUE if the number is odd (not divisible by 2), and FALSE if the number is even or not a number.

Parameter List

Syntax
ISODD(number)
number

The value to test. For example: 3, -5, A1, or 7.9. Non-numeric values will return FALSE.

More details

ISODD tests if a number is not evenly divisible by 2. It returns TRUE for odd numbers (including negative odd numbers) and FALSE for even numbers. Non-numeric values like text, logical values, dates, and errors will return FALSE. Decimal numbers are truncated to integers before testing.

Examples

ISODD() returns 1