IsOdd(number)

Category: Number function

This function tests if number is odd and returns Boolean TRUE if so, or FALSE if not.

Return value type: Boolean (TRUE/FALSE)

Passing in a date value results in a valid result based on the converted date serial value.

isodd(1) //Returns TRUE

isodd(42) //Returns FALSE

isodd(#2021-10-21) //Returns FALSE (2021-10-21 is 44480 as a date serial value, which is not odd.)

isodd(10*100) //Returns FALSE  (Passing in calculations is supported.)

isodd({MyNum}*[MyVal]) //Returns TRUE  ({MyNum}=5, [MyVal]=3; parameters are supported.)

isodd(2.5) //Returns "#The argument must be a whole number."

• IsEven(number)