Documentation/Calc Functions/ISEVEN

Function name:
ISEVEN

Category:
Information

Summary:
Determines whether a supplied number is even or odd. The sign of the number is ignored and if the value is not an integer, then any digits after the decimal separator are ignored.

Syntax:
ISEVEN(Value)

Returns:
Returns TRUE if the argument evaluates to an even number and FALSE if the argument evaluates to an odd number.

Arguments:
Value is an expression, or a reference to a cell containing an expression, that is to be tested for parity.


 * If Value is not an integer, then any digits after the decimal point are ignored.
 * The sign of Value is ignored.
 * If Value evaluates to a string, then ISEVEN reports a parameter list error (Err:504).

Additional details:

 * ISEVEN propagates errors. For example, if cell D1 contains the formula  then the formula   returns the #DIV/0! error.


 * If reference to an empty cell is passed to ISEVEN, then ISEVEN reports a parameter list error (Err:504) whereas Microsoft Excel’s ISEVEN function returns TRUE.


 * If a text string or a reference to a cell containing a text string is passed to ISEVEN, then ISEVEN reports a parameter list error (Err:504) whereas Microsoft Excel’s ISEVEN function reports a #VALUE! error.


 * The ISEVEN_ADD function is similar to ISEVEN but ISEVEN_ADD returns the value 1 for an even number and 0 for an odd number. In addition, ISEVEN_ADD does not report the parameter list error (Err:504) – if passed an empty cell it returns 1 and if passed a text string then it returns the #VALUE! error.

Related LibreOffice functions:
ISEVEN_ADD

ISODD

ODF standard:
Section 6.13.17, part 2

Equivalent Excel functions:
ISEVEN