Documentation/Calc Functions/ISEVEN ADD

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

ISEVEN_ADD

Category:

Information

Summary:

Tests for even numbers.

Syntax:

ISEVEN_ADD(Number)

Returns:

Returns 1 if the number divided by 2 returns a whole number.

Arguments:

Number is the number to be tested.

Additional details:

The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards.

Examples:

=ISEVEN_ADD(5) returns 0.

=ISEVEN_ADD(A1) returns 1 if cell A1 contains the number 2.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: