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

From Apache OpenOffice Wiki

< Documentation | How Tos

OOoWikiBot (Talk | contribs) m (Bot: Adding Category: Documentation) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||

Line 37: | Line 37: | ||

* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||

* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||

− | [[Category: Documentation]] | + | [[Category: Documentation/Reference/Calc]] |

## Revision as of 09:26, 24 November 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**

### Issues:

` ISEVEN_ADD` and

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

**ISODD_ADD**