Documentation/How Tos/Calc: ISEVEN ADD function

From Apache OpenOffice Wiki
Jump to: navigation, search


ISEVEN_ADD

Returns 1 if the value is an even number, or 0 if the value is odd.

This function is only available if the Analysis AddIn is installed.

Syntax:

ISEVEN_ADD(value)

value is the value to be checked.
If value is not an integer any digits after the decimal point are ignored. The sign of value is also ignored.

Example:

ISEVEN_ADD(48)

returns 1.

ISEVEN_ADD(33)

returns 0.

ISEVEN_ADD(0)

returns 1.

ISEVEN_ADD(3.999)

returns 0. Ignoring digits after the decimal point gives 3, which is not even.

ISEVEN_ADD(-2.1)

returns 1. Ignoring the sign and digits after the decimal point gives 2, which is even.

Issues:

ISEVEN_ADD and ISODD_ADD are intended to mimic certain non-standard behaviour in Excel.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ISEVEN_ADD_function&oldid=243339"
Views
Personal tools
Navigation
Print/export
Tools