Difference between revisions of "Documentation/How Tos/Calc: ISEVEN ADD function"

Latest revision as of 13:17, 31 January 2024

FUNCTIONS

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.

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.

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.

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

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:ISEVEN_ADD function}}
+{{Documentation/CalcFunc InformationTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_ISEVEN_function
+|NextPage=Documentation/How_Tos/Calc:_ISLOGICAL_function
+}}__NOTOC__
 == ISEVEN_ADD  ==
@@ Line 11: / Line 16: @@
 :<tt>'''value'''</tt> is the value to be checked.
-:If <tt>'''value'''</tt> is not an integer any digits after the decimal point are ignored. The sign of <tt>'''value'''</tt> is also ignored.
+:If <tt>'''value'''</tt> is not an integer, any digits after the decimal point are ignored. The sign of <tt>'''value'''</tt> is also ignored.
 === Example: ===
@@ Line 26: / Line 31: @@
 === Issues: ===
-<tt>'''ISEVEN_ADD'''</tt> and <tt>'''ISODD_ADD'''</tt> are intended to mimic certain non-standard behaviour in Excel.
+<tt>'''ISEVEN_ADD'''</tt> and <tt>'''ISODD_ADD'''</tt> are intended to mimic certain non-standard behavior in Excel.
-{{Documentation/SeeAlso|
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]]
 * [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]]