Category: Number function

This function tests if number is even 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.

iseven(1) //Returns FALSE

iseven(42) //Returns TRUE

iseven(#2021-10-21) //Returns TRUE  (2021-10-21 is 44480 as a date serial value, which is even.)

iseven(10*100) //Returns TRUE  (Passing in calculations is supported.)

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

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

• IsOdd(number)