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

From Apache OpenOffice Wiki

< Documentation | How Tos

OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) 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

`if the value is even.`

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

### Syntax:

**ISODD_ADD(value)**

is the value to be checked.**value**

- If
is not an integer any digits after the decimal point are ignored. The sign of**value**is also ignored.**value**

### Example:

**ISODD_ADD(33)**

- returns
.**1**

**ISODD_ADD(48)**

- returns
.**0**

**ISODD_ADD(3.999)**

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

**ISODD_ADD(-3.1)**

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

Template:Documentation/SeeAlso

### Issues:

` ISEVEN_ADD` and

`are intended to mimic certain non-standard behaviour in Excel.`

**ISODD_ADD**