Difference between revisions of "Documentation/How Tos/Calc: ISODD 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 36: | Line 36: | ||
* [[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
Returns TRUE if the value is an odd number, or FALSE if the value is even.
Syntax:
ISODD(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(33)
- returns TRUE.
ISODD(48)
- returns FALSE.
ISODD(3.999)
- returns TRUE. Ignoring digits after the decimal point gives 3, which is odd.
ISODD(-3.1)
- returns TRUE. Ignoring the sign and digits after the decimal point gives 3, which is odd.
Issues:
ISEVEN and ISODD are listed in the Mathematical category of the Application Help (OOo2.3). They are clearly similar to other IS functions in returning information, and belong in the Information category; however as they are listed under Mathematical in the Function Wizard, they are currently shown in that category also.
