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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Information_functions|<div style="font-size: 140%;">Information Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_ISODD_ADD_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_ISNUMBER_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Financial_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Logical_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
* [[Documentation/How_Tos/Calc:_CELL_function|<div style="font-size: 120%;">Cell]]
 +
* [[Documentation/How_Tos/Calc:_CURRENT_function|<div style="font-size: 120%;">Current]]
 +
* [[Documentation/How_Tos/Calc:_FORMULA_function|<div style="font-size: 120%;">Formula]]
 +
* [[Documentation/How_Tos/Calc:_ISBLANK_function|<div style="font-size: 120%;">Isblank]]
 +
* [[Documentation/How_Tos/Calc:_ISERR_function|<div style="font-size: 120%;">Iserr]]
 +
* [[Documentation/How_Tos/Calc:_ISERROR_function|<div style="font-size: 120%;">Iserror]]
 +
* [[Documentation/How_Tos/Calc:_ISEVEN_function|<div style="font-size: 120%;">Iseven]]
 +
* [[Documentation/How_Tos/Calc:_ISEVEN_ADD_function|<div style="font-size: 120%;">Iseven Add]]
 +
* [[Documentation/How_Tos/Calc:_ISLOGICAL_function|<div style="font-size: 120%;">Islogical]]
 +
* [[Documentation/How_Tos/Calc:_ISNA_function|<div style="font-size: 120%;">Isna]]
 +
* [[Documentation/How_Tos/Calc:_ISNONTEXT_function|<div style="font-size: 120%;">Isnontext]]
 +
* [[Documentation/How_Tos/Calc:_ISNUMBER_function|<div style="font-size: 120%;">Isnumber]]
 +
* [[Documentation/How_Tos/Calc:_ISODD_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Isodd]]
 +
* [[Documentation/How_Tos/Calc:_ISODD_ADD_function|<div style="font-size: 120%;">Isodd Add]]
 +
* [[Documentation/How_Tos/Calc:_ISREF_function|<div style="font-size: 120%;">Isref]]
 +
* [[Documentation/How_Tos/Calc:_ISTEXT_function|<div style="font-size: 120%;">Istext]]
 +
* [[Documentation/How_Tos/Calc:_N_function|<div style="font-size: 120%;">N]]
 +
* [[Documentation/How_Tos/Calc:_NA_function|<div style="font-size: 120%;">Na]]
 +
* [[Documentation/How_Tos/Calc:_TYPE_function|<div style="font-size: 120%;">Type]]
 +
}}__TOC__
 +
 
  
 
== ISODD  ==
 
== ISODD  ==
 
Returns <tt>'''TRUE'''</tt> if the value is an odd number, or <tt>'''FALSE'''</tt> if the value is even.
 
Returns <tt>'''TRUE'''</tt> if the value is an odd number, or <tt>'''FALSE'''</tt> if the value is even.
−
 
  
 
=== Syntax: ===
 
=== Syntax: ===
Line 11: Line 40:
  
 
:If <tt>'''value'''</tt> is not an integer any digits after the decimal point are ignored. The sign of <tt>'''value'''</tt> is also ignored.
 
:If <tt>'''value'''</tt> is not an integer any digits after the decimal point are ignored. The sign of <tt>'''value'''</tt> is also ignored.
−
 
  
 
=== Example: ===
 
=== Example: ===
Line 26: Line 54:
 
: returns <tt>'''TRUE'''</tt>. Ignoring the sign and digits after the decimal point gives 3, which is odd.
 
: returns <tt>'''TRUE'''</tt>. Ignoring the sign and digits after the decimal point gives 3, which is odd.
  
 +
=== Issues: ===
 +
<tt>'''ISEVEN'''</tt> and <tt>'''ISODD'''</tt> are listed in the Mathematical category of the Application Help (OOo2.3). They are clearly similar to other  <tt>'''IS'''</tt> 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.
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
'''[[Documentation/How_Tos/Calc: ISODD function|ISODD function]]''',
+
* [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]]
−
'''[[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD function]]'''
+
* [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]]
  
−
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]'''
+
* [[Documentation/How_Tos/Calc: Information functions|Information functions]]
 +
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]
  
−
 
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
−
=== See also: ===
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
−
<tt>'''ISEVEN'''</tt> and <tt>'''ISODD'''</tt> are listed in the Mathematical category of the Application Help (OOo2.3). They are clearly similar to other  <tt>'''IS'''</tt> 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.
+
[[Category: Documentation/Reference/Calc/Information functions]]
 +
[[Category: Documentation/Reference/Calc/Mathematical functions]]

Revision as of 12:34, 16 July 2018



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.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_ISODD_function&oldid=243230"
Views
Personal tools
Navigation
Tools