Rows has joined Superhuman. Learn more. The Superhuman Privacy Policy and Terms will apply as of June 16.

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