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

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
m (Robot: Automated text replacement %s)
Line 28: Line 28:
 
{{Documentation/SeeAlso|
 
{{Documentation/SeeAlso|
 
* [[Documentation/How_Tos/Calc: ISODD function|ISODD]]
 
* [[Documentation/How_Tos/Calc: ISODD function|ISODD]]
* [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]]'''
+
* [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]]
  
* [[Documentation/How_Tos/Calc: Information functions|Information functions]]'''
+
* [[Documentation/How_Tos/Calc: Information functions|Information functions]]
  
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]

Revision as of 14:18, 26 February 2009


ISODD_ADD

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

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

Syntax:

ISODD_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:

ISODD_ADD(33)

returns 1.

ISODD_ADD(48)

returns 0.

ISODD_ADD(3.999)

returns 1. Ignoring digits after the decimal point gives 3, which is odd.

ISODD_ADD(-3.1)

returns 1. Ignoring the sign and digits after the decimal point gives 3, which is odd.

Template:Documentation/SeeAlso

Issues:

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

Personal tools