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

From Apache OpenOffice Wiki

< Documentation | How Tos

(Initial content) |
(→See also:) |
||

Line 31: | Line 31: | ||

'''[[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 by category|'''Functions listed by category''']] | ||

=== Issues: === | === 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 behaviour in Excel. |

## Revision as of 06:28, 13 September 2008

## 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**

### See also:

**Functions listed alphabetically**,
**Functions listed by category**

### Issues:

` ISEVEN_ADD` and

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

**ISODD_ADD**