04060106.xhp (02dbb15c) 04060106.xhp (cf7cf155)
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 25 unchanged lines hidden (view full) ---

34<bookmark xml-lang="en-US" branch="index" id="bm_id3147124"><bookmark_value>mathematical functions</bookmark_value>
35<bookmark_value>Function Wizard; mathematical</bookmark_value>
36<bookmark_value>functions; mathematical functions</bookmark_value>
37<bookmark_value>trigonometric functions</bookmark_value>
38</bookmark>
39<paragraph xml-lang="en-US" id="hd_id3147124" role="heading" level="1" l10n="U" oldref="1">Mathematical Functions</paragraph>
40<paragraph xml-lang="en-US" id="par_id3154943" role="paragraph" l10n="CHG" oldref="2"><variable id="mathematiktext">This category contains the <emph>Mathematical</emph> functions for Calc.
41</variable> To open the <emph>Function Wizard</emph>, choose <link href="text/scalc/01/04060000.xhp" name="Insert - Function"><emph>Insert - Function</emph></link>.</paragraph>
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information

--- 25 unchanged lines hidden (view full) ---

34<bookmark xml-lang="en-US" branch="index" id="bm_id3147124"><bookmark_value>mathematical functions</bookmark_value>
35<bookmark_value>Function Wizard; mathematical</bookmark_value>
36<bookmark_value>functions; mathematical functions</bookmark_value>
37<bookmark_value>trigonometric functions</bookmark_value>
38</bookmark>
39<paragraph xml-lang="en-US" id="hd_id3147124" role="heading" level="1" l10n="U" oldref="1">Mathematical Functions</paragraph>
40<paragraph xml-lang="en-US" id="par_id3154943" role="paragraph" l10n="CHG" oldref="2"><variable id="mathematiktext">This category contains the <emph>Mathematical</emph> functions for Calc.
41</variable> To open the <emph>Function Wizard</emph>, choose <link href="text/scalc/01/04060000.xhp" name="Insert - Function"><emph>Insert - Function</emph></link>.</paragraph>
42<sort>
42<sort order="asc" >
43<section id="Section1">
44<bookmark xml-lang="en-US" branch="index" id="bm_id3146944"><bookmark_value>ABS function</bookmark_value>
45<bookmark_value>absolute values</bookmark_value>
46<bookmark_value>values;absolute</bookmark_value>
47</bookmark><comment>mw added two entries</comment>
48<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695" localize="false"/>
49<paragraph xml-lang="en-US" id="hd_id3146944" role="heading" level="2" l10n="U"
50oldref="33">ABS</paragraph>

--- 102 unchanged lines hidden (view full) ---

153oldref="85">Example</paragraph>
154<paragraph xml-lang="en-US" id="par_id3150608" role="paragraph" l10n="CHG" oldref="86">
155<item type="input">=ACOTH(1.1)</item> returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.</paragraph><comment>see also ACOSH, ASINH, ATANH, COSH, SINH, TANH, COTH</comment>
156</section>
157<section id="Section57">
158<bookmark xml-lang="en-US" branch="index" id="bm_id3145084"><bookmark_value>ASIN function</bookmark_value>
159</bookmark>
160<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/>
43<section id="Section1">
44<bookmark xml-lang="en-US" branch="index" id="bm_id3146944"><bookmark_value>ABS function</bookmark_value>
45<bookmark_value>absolute values</bookmark_value>
46<bookmark_value>values;absolute</bookmark_value>
47</bookmark><comment>mw added two entries</comment>
48<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695" localize="false"/>
49<paragraph xml-lang="en-US" id="hd_id3146944" role="heading" level="2" l10n="U"
50oldref="33">ABS</paragraph>

--- 102 unchanged lines hidden (view full) ---

153oldref="85">Example</paragraph>
154<paragraph xml-lang="en-US" id="par_id3150608" role="paragraph" l10n="CHG" oldref="86">
155<item type="input">=ACOTH(1.1)</item> returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.</paragraph><comment>see also ACOSH, ASINH, ATANH, COSH, SINH, TANH, COTH</comment>
156</section>
157<section id="Section57">
158<bookmark xml-lang="en-US" branch="index" id="bm_id3145084"><bookmark_value>ASIN function</bookmark_value>
159</bookmark>
160<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/>
161<paragraph xml-lang="en-US" id="hd_id3145084" role="heading" level="2" l10n="U"
162oldref="90">ASIN</paragraph>
161<paragraph xml-lang="en-US" id="hd_id3145084" role="heading" level="2" l10n="U" oldref="90">ASIN</paragraph>
163<paragraph xml-lang="en-US" id="par_id3156296" role="paragraph" l10n="CHG" oldref="91"><ahelp hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a number.</ahelp></paragraph>
162<paragraph xml-lang="en-US" id="par_id3156296" role="paragraph" l10n="CHG" oldref="91"><ahelp hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a number.</ahelp></paragraph>
164<paragraph xml-lang="en-US" id="hd_id3149716" role="heading" level="3" l10n="U"
165oldref="92">Syntax</paragraph>
163<paragraph xml-lang="en-US" id="hd_id3149716" role="heading" level="3" l10n="U" oldref="92">Syntax</paragraph>
166<paragraph xml-lang="en-US" id="par_id3156305" role="code" l10n="U" oldref="93">ASIN(Number)</paragraph>
167<paragraph xml-lang="en-US" id="par_id3150964" role="paragraph" l10n="CHG" oldref="94"> This function returns the inverse trigonometric sine of <emph>Number</emph>, that is the angle (in radians) whose sine is Number. The angle returned is between -PI/2 and +PI/2.</paragraph>
168<paragraph xml-lang="en-US" id="par_id203863" role="paragraph" l10n="NEW">To return the angle in degrees, use the DEGREES function.</paragraph>
164<paragraph xml-lang="en-US" id="par_id3156305" role="code" l10n="U" oldref="93">ASIN(Number)</paragraph>
165<paragraph xml-lang="en-US" id="par_id3150964" role="paragraph" l10n="CHG" oldref="94"> This function returns the inverse trigonometric sine of <emph>Number</emph>, that is the angle (in radians) whose sine is Number. The angle returned is between -PI/2 and +PI/2.</paragraph>
166<paragraph xml-lang="en-US" id="par_id203863" role="paragraph" l10n="NEW">To return the angle in degrees, use the DEGREES function.</paragraph>
169<paragraph xml-lang="en-US" id="hd_id3149448" role="heading" level="3" l10n="U"
170oldref="95">Example</paragraph>
167<paragraph xml-lang="en-US" id="hd_id3149448" role="heading" level="3" l10n="U" oldref="95">Example</paragraph>
171<paragraph xml-lang="en-US" id="par_id3156100" role="paragraph" l10n="CHG" oldref="96">
172<item type="input">=ASIN(0)</item> returns 0.</paragraph>
173<paragraph xml-lang="en-US" id="par_id6853846" role="paragraph" l10n="NEW">
174<item type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians). </paragraph>
175<paragraph xml-lang="en-US" id="par_id8772240" role="paragraph" l10n="NEW">
176<item type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30 degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2, ACOT </comment>
177</section>
178<section id="Section56">
179<bookmark xml-lang="en-US" branch="index" id="bm_id3151266"><bookmark_value>ASINH function</bookmark_value>
180</bookmark>
181<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206" localize="false"/>
168<paragraph xml-lang="en-US" id="par_id3156100" role="paragraph" l10n="CHG" oldref="96">
169<item type="input">=ASIN(0)</item> returns 0.</paragraph>
170<paragraph xml-lang="en-US" id="par_id6853846" role="paragraph" l10n="NEW">
171<item type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians). </paragraph>
172<paragraph xml-lang="en-US" id="par_id8772240" role="paragraph" l10n="NEW">
173<item type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30 degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2, ACOT </comment>
174</section>
175<section id="Section56">
176<bookmark xml-lang="en-US" branch="index" id="bm_id3151266"><bookmark_value>ASINH function</bookmark_value>
177</bookmark>
178<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206" localize="false"/>
182<paragraph xml-lang="en-US" id="hd_id3151266" role="heading" level="2" l10n="U"
183oldref="100">ASINH</paragraph>
179<paragraph xml-lang="en-US" id="hd_id3151266" role="heading" level="2" l10n="U" oldref="100">ASINH</paragraph>
184<paragraph xml-lang="en-US" id="par_id3147077" role="paragraph" l10n="U" oldref="101"><ahelp hid="HID_FUNC_ARSINHYP">Returns the inverse hyperbolic sine of a number.</ahelp></paragraph>
185<paragraph xml-lang="en-US" id="hd_id3150763" role="heading" level="3" l10n="U"
186oldref="102">Syntax</paragraph>
187<paragraph xml-lang="en-US" id="par_id3150882" role="code" l10n="U" oldref="103">ASINH(Number)</paragraph>
188<paragraph xml-lang="en-US" id="par_id3147621" role="paragraph" l10n="CHG" oldref="104"> This function returns the inverse hyperbolic sine of <emph>Number</emph>, that is the number whose hyperbolic sine is Number. </paragraph>
189<paragraph xml-lang="en-US" id="hd_id3153212" role="heading" level="3" l10n="U"
190oldref="105">Example</paragraph>
191<paragraph xml-lang="en-US" id="par_id3156120" role="paragraph" l10n="CHG" oldref="106">

--- 21 unchanged lines hidden (view full) ---

213<paragraph xml-lang="en-US" id="par_id8746299" role="paragraph" l10n="NEW">
214<item type="input">=DEGREES(ATAN(1))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT,
215ACOS, ASIN, ATAN2, ACOT </comment>
216</section>
217<section id="Section54">
218<bookmark xml-lang="en-US" branch="index" id="bm_id3153983"><bookmark_value>ATAN2 function</bookmark_value>
219</bookmark>
220<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/>
180<paragraph xml-lang="en-US" id="par_id3147077" role="paragraph" l10n="U" oldref="101"><ahelp hid="HID_FUNC_ARSINHYP">Returns the inverse hyperbolic sine of a number.</ahelp></paragraph>
181<paragraph xml-lang="en-US" id="hd_id3150763" role="heading" level="3" l10n="U"
182oldref="102">Syntax</paragraph>
183<paragraph xml-lang="en-US" id="par_id3150882" role="code" l10n="U" oldref="103">ASINH(Number)</paragraph>
184<paragraph xml-lang="en-US" id="par_id3147621" role="paragraph" l10n="CHG" oldref="104"> This function returns the inverse hyperbolic sine of <emph>Number</emph>, that is the number whose hyperbolic sine is Number. </paragraph>
185<paragraph xml-lang="en-US" id="hd_id3153212" role="heading" level="3" l10n="U"
186oldref="105">Example</paragraph>
187<paragraph xml-lang="en-US" id="par_id3156120" role="paragraph" l10n="CHG" oldref="106">

--- 21 unchanged lines hidden (view full) ---

209<paragraph xml-lang="en-US" id="par_id8746299" role="paragraph" l10n="NEW">
210<item type="input">=DEGREES(ATAN(1))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT,
211ACOS, ASIN, ATAN2, ACOT </comment>
212</section>
213<section id="Section54">
214<bookmark xml-lang="en-US" branch="index" id="bm_id3153983"><bookmark_value>ATAN2 function</bookmark_value>
215</bookmark>
216<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/>
221<paragraph xml-lang="en-US" id="hd_id3153983" role="heading" level="2" l10n="U"
222oldref="120">ATAN2</paragraph>
217<paragraph xml-lang="en-US" id="hd_id3153983" role="heading" level="2" l10n="U" oldref="120">ATAN2</paragraph>
223<paragraph xml-lang="en-US" id="par_id3154297" role="paragraph" l10n="CHG" oldref="121"><ahelp hid="HID_FUNC_ARCTAN2">Returns the inverse trigonometric tangent of the specified x and y coordinates.</ahelp></paragraph>
218<paragraph xml-lang="en-US" id="par_id3154297" role="paragraph" l10n="CHG" oldref="121"><ahelp hid="HID_FUNC_ARCTAN2">Returns the inverse trigonometric tangent of the specified x and y coordinates.</ahelp></paragraph>
224<paragraph xml-lang="en-US" id="hd_id3149758" role="heading" level="3" l10n="U"
225oldref="122">Syntax</paragraph>
219<paragraph xml-lang="en-US" id="hd_id3149758" role="heading" level="3" l10n="U" oldref="122">Syntax</paragraph>
226<paragraph xml-lang="en-US" id="par_id3156013" role="code" l10n="CHG" oldref="123">ATAN2(NumberX; NumberY)</paragraph>
227<paragraph xml-lang="en-US" id="par_id3151168" role="paragraph" l10n="CHG" oldref="124"><emph>NumberX</emph> is the value of the x coordinate.</paragraph>
228<paragraph xml-lang="en-US" id="par_id3152798" role="paragraph" l10n="CHG" oldref="125"><emph>NumberY</emph> is the value of the y coordinate.</paragraph>
229<paragraph xml-lang="en-US" id="par_id5036164" role="paragraph" l10n="NEW">ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI.</paragraph>
230<paragraph xml-lang="en-US" id="par_id3001800" role="paragraph" l10n="NEW">To return the angle in degrees, use the DEGREES function.</paragraph>
231<paragraph xml-lang="en-US" id="hd_id3145663" role="heading" level="3" l10n="U"
232oldref="126">Example</paragraph>
233<paragraph xml-lang="en-US" id="par_id3154692" role="paragraph" l10n="CHG" oldref="127">

--- 22 unchanged lines hidden (view full) ---

256</section>
257<section id="Section52">
258<bookmark xml-lang="en-US" branch="index" id="bm_id3153062"><bookmark_value>COS function</bookmark_value>
259</bookmark>
260<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COS" id="bm_id3158408" localize="false"/>
261<paragraph xml-lang="en-US" id="hd_id3153062" role="heading" level="2" l10n="U"
262oldref="149">COS</paragraph>
263<paragraph xml-lang="en-US" id="par_id3148803" role="paragraph" l10n="CHG" oldref="150"><ahelp hid="HID_FUNC_COS">Returns the cosine of the given angle (in radians).</ahelp></paragraph>
220<paragraph xml-lang="en-US" id="par_id3156013" role="code" l10n="CHG" oldref="123">ATAN2(NumberX; NumberY)</paragraph>
221<paragraph xml-lang="en-US" id="par_id3151168" role="paragraph" l10n="CHG" oldref="124"><emph>NumberX</emph> is the value of the x coordinate.</paragraph>
222<paragraph xml-lang="en-US" id="par_id3152798" role="paragraph" l10n="CHG" oldref="125"><emph>NumberY</emph> is the value of the y coordinate.</paragraph>
223<paragraph xml-lang="en-US" id="par_id5036164" role="paragraph" l10n="NEW">ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI.</paragraph>
224<paragraph xml-lang="en-US" id="par_id3001800" role="paragraph" l10n="NEW">To return the angle in degrees, use the DEGREES function.</paragraph>
225<paragraph xml-lang="en-US" id="hd_id3145663" role="heading" level="3" l10n="U"
226oldref="126">Example</paragraph>
227<paragraph xml-lang="en-US" id="par_id3154692" role="paragraph" l10n="CHG" oldref="127">

--- 22 unchanged lines hidden (view full) ---

250</section>
251<section id="Section52">
252<bookmark xml-lang="en-US" branch="index" id="bm_id3153062"><bookmark_value>COS function</bookmark_value>
253</bookmark>
254<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COS" id="bm_id3158408" localize="false"/>
255<paragraph xml-lang="en-US" id="hd_id3153062" role="heading" level="2" l10n="U"
256oldref="149">COS</paragraph>
257<paragraph xml-lang="en-US" id="par_id3148803" role="paragraph" l10n="CHG" oldref="150"><ahelp hid="HID_FUNC_COS">Returns the cosine of the given angle (in radians).</ahelp></paragraph>
264<paragraph xml-lang="en-US" id="hd_id3150779" role="heading" level="3" l10n="U"
265oldref="151">Syntax</paragraph>
258<paragraph xml-lang="en-US" id="hd_id3150779" role="heading" level="3" l10n="U" oldref="151">Syntax</paragraph>
266<paragraph xml-lang="en-US" id="par_id3154213" role="code" l10n="U" oldref="152">COS(Number)</paragraph>
267<paragraph xml-lang="en-US" id="par_id3154285" role="paragraph" l10n="CHG" oldref="153"> Returns the (trigonometric) cosine of <emph>Number</emph>, the angle in radians.</paragraph>
268<paragraph xml-lang="en-US" id="par_id831019" role="paragraph" l10n="NEW">To return the cosine of an angle in degrees, use the RADIANS function.</paragraph>
259<paragraph xml-lang="en-US" id="par_id3154213" role="code" l10n="U" oldref="152">COS(Number)</paragraph>
260<paragraph xml-lang="en-US" id="par_id3154285" role="paragraph" l10n="CHG" oldref="153"> Returns the (trigonometric) cosine of <emph>Number</emph>, the angle in radians.</paragraph>
261<paragraph xml-lang="en-US" id="par_id831019" role="paragraph" l10n="NEW">To return the cosine of an angle in degrees, use the RADIANS function.</paragraph>
269<paragraph xml-lang="en-US" id="hd_id3153579" role="heading" level="3" l10n="U"
270oldref="154">Examples</paragraph>
262<paragraph xml-lang="en-US" id="hd_id3153579" role="heading" level="3" l10n="U" oldref="154">Examples</paragraph>
271<paragraph xml-lang="en-US" id="par_id3147240" role="paragraph" l10n="U" oldref="155">
272<item type="input">=COS(PI()/2)</item> returns 0, the cosine of PI/2 radians.</paragraph>
273<paragraph xml-lang="en-US" id="par_id3147516" role="paragraph" l10n="U" oldref="156">
274<item type="input">=COS(RADIANS(60))</item> returns 0.5, the cosine of 60 degrees.</paragraph><comment>see also SIN, TAN, COT,
275ACOS, ASIN, ATAN, ATAN2, ACOT </comment>
276</section>
277<section id="Section51">
278<bookmark xml-lang="en-US" branch="index" id="bm_id3154277"><bookmark_value>COSH function</bookmark_value>
279</bookmark>
280<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/>
263<paragraph xml-lang="en-US" id="par_id3147240" role="paragraph" l10n="U" oldref="155">
264<item type="input">=COS(PI()/2)</item> returns 0, the cosine of PI/2 radians.</paragraph>
265<paragraph xml-lang="en-US" id="par_id3147516" role="paragraph" l10n="U" oldref="156">
266<item type="input">=COS(RADIANS(60))</item> returns 0.5, the cosine of 60 degrees.</paragraph><comment>see also SIN, TAN, COT,
267ACOS, ASIN, ATAN, ATAN2, ACOT </comment>
268</section>
269<section id="Section51">
270<bookmark xml-lang="en-US" branch="index" id="bm_id3154277"><bookmark_value>COSH function</bookmark_value>
271</bookmark>
272<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/>
281<paragraph xml-lang="en-US" id="hd_id3154277" role="heading" level="2" l10n="U"
282oldref="159">COSH</paragraph>
273<paragraph xml-lang="en-US" id="hd_id3154277" role="heading" level="2" l10n="U" oldref="159">COSH</paragraph>
283<paragraph xml-lang="en-US" id="par_id3146946" role="paragraph" l10n="U" oldref="160"><ahelp hid="HID_FUNC_COSHYP">Returns the hyperbolic cosine of a number.</ahelp></paragraph>
274<paragraph xml-lang="en-US" id="par_id3146946" role="paragraph" l10n="U" oldref="160"><ahelp hid="HID_FUNC_COSHYP">Returns the hyperbolic cosine of a number.</ahelp></paragraph>
284<paragraph xml-lang="en-US" id="hd_id3149792" role="heading" level="3" l10n="U"
285oldref="161">Syntax</paragraph>
275<paragraph xml-lang="en-US" id="hd_id3149792" role="heading" level="3" l10n="U" oldref="161">Syntax</paragraph>
286<paragraph xml-lang="en-US" id="par_id3166440" role="code" l10n="U" oldref="162">COSH(Number)</paragraph>
287<paragraph xml-lang="en-US" id="par_id3150710" role="paragraph" l10n="CHG" oldref="163">Returns the hyperbolic cosine of <emph>Number</emph>.</paragraph>
276<paragraph xml-lang="en-US" id="par_id3166440" role="code" l10n="U" oldref="162">COSH(Number)</paragraph>
277<paragraph xml-lang="en-US" id="par_id3150710" role="paragraph" l10n="CHG" oldref="163">Returns the hyperbolic cosine of <emph>Number</emph>.</paragraph>
288<paragraph xml-lang="en-US" id="hd_id3153234" role="heading" level="3" l10n="U"
289oldref="164">Example</paragraph>
278<paragraph xml-lang="en-US" id="hd_id3153234" role="heading" level="3" l10n="U" oldref="164">Example</paragraph>
290<paragraph xml-lang="en-US" id="par_id3154099" role="paragraph" l10n="CHG" oldref="165">
291<item type="input">=COSH(0)</item> returns 1, the hyperbolic cosine of 0.</paragraph><comment>see also SINH, TANH, COTH,
292ACOSH, ASINH, ATANH, ACOTH, </comment>
293</section>
294<section id="Section50">
295<bookmark xml-lang="en-US" branch="index" id="bm_id3152888"><bookmark_value>COT function</bookmark_value>
296</bookmark>
297<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COT" id="bm_id3153392" localize="false"/>
279<paragraph xml-lang="en-US" id="par_id3154099" role="paragraph" l10n="CHG" oldref="165">
280<item type="input">=COSH(0)</item> returns 1, the hyperbolic cosine of 0.</paragraph><comment>see also SINH, TANH, COTH,
281ACOSH, ASINH, ATANH, ACOTH, </comment>
282</section>
283<section id="Section50">
284<bookmark xml-lang="en-US" branch="index" id="bm_id3152888"><bookmark_value>COT function</bookmark_value>
285</bookmark>
286<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COT" id="bm_id3153392" localize="false"/>
298<paragraph xml-lang="en-US" id="hd_id3152888" role="heading" level="2" l10n="U"
299oldref="169">COT</paragraph>
287<paragraph xml-lang="en-US" id="hd_id3152888" role="heading" level="2" l10n="U" oldref="169">COT</paragraph>
300<paragraph xml-lang="en-US" id="par_id3153679" role="paragraph" l10n="CHG" oldref="170"><ahelp hid="HID_FUNC_COT">Returns the cotangent of the given angle (in radians).</ahelp></paragraph>
288<paragraph xml-lang="en-US" id="par_id3153679" role="paragraph" l10n="CHG" oldref="170"><ahelp hid="HID_FUNC_COT">Returns the cotangent of the given angle (in radians).</ahelp></paragraph>
301<paragraph xml-lang="en-US" id="hd_id3152943" role="heading" level="3" l10n="U"
302oldref="171">Syntax</paragraph>
289<paragraph xml-lang="en-US" id="hd_id3152943" role="heading" level="3" l10n="U" oldref="171">Syntax</paragraph>
303<paragraph xml-lang="en-US" id="par_id3154856" role="code" l10n="U" oldref="172">COT(Number)</paragraph>
304<paragraph xml-lang="en-US" id="par_id3149969" role="paragraph" l10n="CHG" oldref="173"> Returns the (trigonometric) cotangent of <emph>Number</emph>, the angle in radians.</paragraph>
305<paragraph xml-lang="en-US" id="par_id3444624" role="paragraph" l10n="NEW">To return the cotangent of an angle in degrees, use the RADIANS function.</paragraph>
306<paragraph xml-lang="en-US" id="par_id6814477" role="paragraph" l10n="NEW">The cotangent of an angle is equivalent to 1 divided by the tangent of that angle.</paragraph>
307<paragraph xml-lang="en-US" id="hd_id3149800" role="heading" level="3" l10n="U"
308oldref="174">Examples:</paragraph>
309<paragraph xml-lang="en-US" id="par_id3148616" role="paragraph" l10n="CHG" oldref="175">
310<item type="input">=COT(PI()/4)</item> returns 1, the cotangent of PI/4 radians.</paragraph>
311<paragraph xml-lang="en-US" id="par_id3148986" role="paragraph" l10n="CHG" oldref="176">
312<item type="input">=COT(RADIANS(45))</item> returns 1, the cotangent of 45 degrees.</paragraph><comment>see also COS, SIN, TAN,
313ACOS, ASIN, ATAN, ATAN2, ACOT </comment>
314</section>
315<section id="Section49">
316<bookmark xml-lang="en-US" branch="index" id="bm_id3154337"><bookmark_value>COTH function</bookmark_value>
317</bookmark>
318<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/>
290<paragraph xml-lang="en-US" id="par_id3154856" role="code" l10n="U" oldref="172">COT(Number)</paragraph>
291<paragraph xml-lang="en-US" id="par_id3149969" role="paragraph" l10n="CHG" oldref="173"> Returns the (trigonometric) cotangent of <emph>Number</emph>, the angle in radians.</paragraph>
292<paragraph xml-lang="en-US" id="par_id3444624" role="paragraph" l10n="NEW">To return the cotangent of an angle in degrees, use the RADIANS function.</paragraph>
293<paragraph xml-lang="en-US" id="par_id6814477" role="paragraph" l10n="NEW">The cotangent of an angle is equivalent to 1 divided by the tangent of that angle.</paragraph>
294<paragraph xml-lang="en-US" id="hd_id3149800" role="heading" level="3" l10n="U"
295oldref="174">Examples:</paragraph>
296<paragraph xml-lang="en-US" id="par_id3148616" role="paragraph" l10n="CHG" oldref="175">
297<item type="input">=COT(PI()/4)</item> returns 1, the cotangent of PI/4 radians.</paragraph>
298<paragraph xml-lang="en-US" id="par_id3148986" role="paragraph" l10n="CHG" oldref="176">
299<item type="input">=COT(RADIANS(45))</item> returns 1, the cotangent of 45 degrees.</paragraph><comment>see also COS, SIN, TAN,
300ACOS, ASIN, ATAN, ATAN2, ACOT </comment>
301</section>
302<section id="Section49">
303<bookmark xml-lang="en-US" branch="index" id="bm_id3154337"><bookmark_value>COTH function</bookmark_value>
304</bookmark>
305<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/>
319<paragraph xml-lang="en-US" id="hd_id3154337" role="heading" level="2" l10n="U"
320oldref="178">COTH</paragraph>
306<paragraph xml-lang="en-US" id="hd_id3154337" role="heading" level="2" l10n="U" oldref="178">COTH</paragraph>
321<paragraph xml-lang="en-US" id="par_id3149419" role="paragraph" l10n="U" oldref="179"><ahelp hid="HID_FUNC_COTHYP">Returns the hyperbolic cotangent of a given number (angle).</ahelp></paragraph>
322<paragraph xml-lang="en-US" id="hd_id3149242" role="heading" level="3" l10n="U"
323oldref="180">Syntax</paragraph>
324<paragraph xml-lang="en-US" id="par_id3143280" role="code" l10n="U" oldref="181">COTH(Number)</paragraph>
325<paragraph xml-lang="en-US" id="par_id3154799" role="paragraph" l10n="CHG" oldref="182"> Returns the hyperbolic cotangent of <emph>Number</emph>.</paragraph>
326<paragraph xml-lang="en-US" id="hd_id3155422" role="heading" level="3" l10n="U"
327oldref="183">Example</paragraph>
328<paragraph xml-lang="en-US" id="par_id3144754" role="paragraph" l10n="CHG" oldref="184">
329<item type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1, approximately 1.3130.</paragraph><comment>see also COSH, SINH, TANH,
330ACOSH, ASINH, ATANH, ACOTH, </comment>
331</section>
332<section id="Section48">
333<bookmark xml-lang="en-US" branch="index" id="bm_id3145314"><bookmark_value>DEGREES function</bookmark_value>
334<bookmark_value>converting;radians, into degrees</bookmark_value>
335</bookmark><comment>mw added one entry</comment>
336<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946" localize="false"/>
307<paragraph xml-lang="en-US" id="par_id3149419" role="paragraph" l10n="U" oldref="179"><ahelp hid="HID_FUNC_COTHYP">Returns the hyperbolic cotangent of a given number (angle).</ahelp></paragraph>
308<paragraph xml-lang="en-US" id="hd_id3149242" role="heading" level="3" l10n="U"
309oldref="180">Syntax</paragraph>
310<paragraph xml-lang="en-US" id="par_id3143280" role="code" l10n="U" oldref="181">COTH(Number)</paragraph>
311<paragraph xml-lang="en-US" id="par_id3154799" role="paragraph" l10n="CHG" oldref="182"> Returns the hyperbolic cotangent of <emph>Number</emph>.</paragraph>
312<paragraph xml-lang="en-US" id="hd_id3155422" role="heading" level="3" l10n="U"
313oldref="183">Example</paragraph>
314<paragraph xml-lang="en-US" id="par_id3144754" role="paragraph" l10n="CHG" oldref="184">
315<item type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1, approximately 1.3130.</paragraph><comment>see also COSH, SINH, TANH,
316ACOSH, ASINH, ATANH, ACOTH, </comment>
317</section>
318<section id="Section48">
319<bookmark xml-lang="en-US" branch="index" id="bm_id3145314"><bookmark_value>DEGREES function</bookmark_value>
320<bookmark_value>converting;radians, into degrees</bookmark_value>
321</bookmark><comment>mw added one entry</comment>
322<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946" localize="false"/>
337<paragraph xml-lang="en-US" id="hd_id3145314" role="heading" level="2" l10n="U"
338oldref="188">DEGREES</paragraph>
323<paragraph xml-lang="en-US" id="hd_id3145314" role="heading" level="2" l10n="U" oldref="188">DEGREES</paragraph>
339<paragraph xml-lang="en-US" id="par_id3149939" role="paragraph" l10n="U" oldref="189"><ahelp hid="HID_FUNC_DEG">Converts radians into degrees.</ahelp></paragraph>
324<paragraph xml-lang="en-US" id="par_id3149939" role="paragraph" l10n="U" oldref="189"><ahelp hid="HID_FUNC_DEG">Converts radians into degrees.</ahelp></paragraph>
340<paragraph xml-lang="en-US" id="hd_id3150623" role="heading" level="3" l10n="U"
341oldref="190">Syntax</paragraph>
325<paragraph xml-lang="en-US" id="hd_id3150623" role="heading" level="3" l10n="U" oldref="190">Syntax</paragraph>
342<paragraph xml-lang="en-US" id="par_id3145600" role="code" l10n="CHG" oldref="191">DEGREES(Number)</paragraph>
343<paragraph xml-lang="en-US" id="par_id3149484" role="paragraph" l10n="CHG" oldref="192"><emph>Number</emph> is the angle in radians to be converted to degrees.</paragraph>
344<paragraph xml-lang="en-US" id="hd_id3669545" role="heading" level="3" l10n="NEW">Example</paragraph>
345<paragraph xml-lang="en-US" id="par_id3459578" role="paragraph" l10n="NEW">
346<item type="input">=DEGREES(PI())</item> returns 180 degrees.</paragraph><comment>see also RADIANS</comment>
347</section>
348<section id="Section47">
349<bookmark xml-lang="en-US" branch="index" id="bm_id3148698"><bookmark_value>EXP function</bookmark_value>
350</bookmark>
351<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
352<paragraph xml-lang="en-US" id="hd_id3148698" role="heading" level="2" l10n="U"
353oldref="198">EXP</paragraph>
354<paragraph xml-lang="en-US" id="par_id3150592" role="paragraph" l10n="CHG" oldref="199"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
326<paragraph xml-lang="en-US" id="par_id3145600" role="code" l10n="CHG" oldref="191">DEGREES(Number)</paragraph>
327<paragraph xml-lang="en-US" id="par_id3149484" role="paragraph" l10n="CHG" oldref="192"><emph>Number</emph> is the angle in radians to be converted to degrees.</paragraph>
328<paragraph xml-lang="en-US" id="hd_id3669545" role="heading" level="3" l10n="NEW">Example</paragraph>
329<paragraph xml-lang="en-US" id="par_id3459578" role="paragraph" l10n="NEW">
330<item type="input">=DEGREES(PI())</item> returns 180 degrees.</paragraph><comment>see also RADIANS</comment>
331</section>
332<section id="Section47">
333<bookmark xml-lang="en-US" branch="index" id="bm_id3148698"><bookmark_value>EXP function</bookmark_value>
334</bookmark>
335<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/>
336<paragraph xml-lang="en-US" id="hd_id3148698" role="heading" level="2" l10n="U"
337oldref="198">EXP</paragraph>
338<paragraph xml-lang="en-US" id="par_id3150592" role="paragraph" l10n="CHG" oldref="199"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph>
355<paragraph xml-lang="en-US" id="hd_id3150351" role="heading" level="3" l10n="U"
356oldref="200">Syntax</paragraph>
339<paragraph xml-lang="en-US" id="hd_id3150351" role="heading" level="3" l10n="U" oldref="200">Syntax</paragraph>
357<paragraph xml-lang="en-US" id="par_id3146786" role="code" l10n="U" oldref="201">EXP(Number)</paragraph>
358<paragraph xml-lang="en-US" id="par_id3155608" role="paragraph" l10n="U" oldref="202"><emph>Number</emph> is the power to which e is to be raised.</paragraph>
340<paragraph xml-lang="en-US" id="par_id3146786" role="code" l10n="U" oldref="201">EXP(Number)</paragraph>
341<paragraph xml-lang="en-US" id="par_id3155608" role="paragraph" l10n="U" oldref="202"><emph>Number</emph> is the power to which e is to be raised.</paragraph>
359<paragraph xml-lang="en-US" id="hd_id3154418" role="heading" level="3" l10n="U"
360oldref="203">Example</paragraph>
342<paragraph xml-lang="en-US" id="hd_id3154418" role="heading" level="3" l10n="U" oldref="203">Example</paragraph>
361<paragraph xml-lang="en-US" id="par_id3156340" role="paragraph" l10n="CHG" oldref="204">
362<item type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant e to Calc's accuracy.</paragraph><comment>see also POWER, LN, </comment>
363</section>
364<section id="Section46">
365<bookmark xml-lang="en-US" branch="index" id="bm_id3145781"><bookmark_value>FACT function</bookmark_value>
366<bookmark_value>factorials;numbers</bookmark_value>
367</bookmark><comment>mw added one entry</comment>
368<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FAKULTAET" id="bm_id3153886" localize="false"/>
343<paragraph xml-lang="en-US" id="par_id3156340" role="paragraph" l10n="CHG" oldref="204">
344<item type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant e to Calc's accuracy.</paragraph><comment>see also POWER, LN, </comment>
345</section>
346<section id="Section46">
347<bookmark xml-lang="en-US" branch="index" id="bm_id3145781"><bookmark_value>FACT function</bookmark_value>
348<bookmark_value>factorials;numbers</bookmark_value>
349</bookmark><comment>mw added one entry</comment>
350<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FAKULTAET" id="bm_id3153886" localize="false"/>
369<paragraph xml-lang="en-US" id="hd_id3145781" role="heading" level="2" l10n="U"
370oldref="208">FACT</paragraph>
351<paragraph xml-lang="en-US" id="hd_id3145781" role="heading" level="2" l10n="U" oldref="208">FACT</paragraph>
371<paragraph xml-lang="en-US" id="par_id3151109" role="paragraph" l10n="CHG" oldref="209"><ahelp hid="HID_FUNC_FAKULTAET">Returns the factorial of a number.</ahelp></paragraph>
352<paragraph xml-lang="en-US" id="par_id3151109" role="paragraph" l10n="CHG" oldref="209"><ahelp hid="HID_FUNC_FAKULTAET">Returns the factorial of a number.</ahelp></paragraph>
372<paragraph xml-lang="en-US" id="hd_id3146902" role="heading" level="3" l10n="U"
373oldref="210">Syntax</paragraph>
353<paragraph xml-lang="en-US" id="hd_id3146902" role="heading" level="3" l10n="U" oldref="210">Syntax</paragraph>
374<paragraph xml-lang="en-US" id="par_id3154661" role="code" l10n="U" oldref="211">FACT(Number)</paragraph>
375<paragraph xml-lang="en-US" id="par_id3152952" role="paragraph" l10n="CHG" oldref="212"> Returns Number!, the factorial of <emph>Number</emph>, calculated as 1*2*3*4* ... * Number.</paragraph>
376<paragraph xml-lang="en-US" id="par_id3834650" role="paragraph" l10n="NEW">=FACT(0) returns 1 by definition. </paragraph>
377<paragraph xml-lang="en-US" id="par_id8429517" role="paragraph" l10n="NEW">The factorial of a negative number returns the "invalid argument" error.</paragraph>
354<paragraph xml-lang="en-US" id="par_id3154661" role="code" l10n="U" oldref="211">FACT(Number)</paragraph>
355<paragraph xml-lang="en-US" id="par_id3152952" role="paragraph" l10n="CHG" oldref="212"> Returns Number!, the factorial of <emph>Number</emph>, calculated as 1*2*3*4* ... * Number.</paragraph>
356<paragraph xml-lang="en-US" id="par_id3834650" role="paragraph" l10n="NEW">=FACT(0) returns 1 by definition. </paragraph>
357<paragraph xml-lang="en-US" id="par_id8429517" role="paragraph" l10n="NEW">The factorial of a negative number returns the "invalid argument" error.</paragraph>
378<paragraph xml-lang="en-US" id="hd_id3154569" role="heading" level="3" l10n="U"
379oldref="213">Example</paragraph>
358<paragraph xml-lang="en-US" id="hd_id3154569" role="heading" level="3" l10n="U" oldref="213">Example</paragraph>
380<paragraph xml-lang="en-US" id="par_id3154476" role="paragraph" l10n="CHG" oldref="216">
381<item type="input">=FACT(3)</item> returns 6.</paragraph>
382<paragraph xml-lang="en-US" id="par_id3147525" role="paragraph" l10n="CHG" oldref="214">
383<item type="input">=FACT(0)</item> returns 1.</paragraph><comment>see also FACTDOUBLE, MULTINOMIAL, PRODUCT </comment>
384</section>
385<section id="Section45">
386<bookmark xml-lang="en-US" branch="index" id="bm_id3159084"><bookmark_value>INT function</bookmark_value>
387<bookmark_value>numbers;rounding down to next integer</bookmark_value>
388<bookmark_value>rounding;down to next integer</bookmark_value>
389</bookmark><comment>mw added two entries</comment>
390<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311" localize="false"/>
359<paragraph xml-lang="en-US" id="par_id3154476" role="paragraph" l10n="CHG" oldref="216">
360<item type="input">=FACT(3)</item> returns 6.</paragraph>
361<paragraph xml-lang="en-US" id="par_id3147525" role="paragraph" l10n="CHG" oldref="214">
362<item type="input">=FACT(0)</item> returns 1.</paragraph><comment>see also FACTDOUBLE, MULTINOMIAL, PRODUCT </comment>
363</section>
364<section id="Section45">
365<bookmark xml-lang="en-US" branch="index" id="bm_id3159084"><bookmark_value>INT function</bookmark_value>
366<bookmark_value>numbers;rounding down to next integer</bookmark_value>
367<bookmark_value>rounding;down to next integer</bookmark_value>
368</bookmark><comment>mw added two entries</comment>
369<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311" localize="false"/>
391<paragraph xml-lang="en-US" id="hd_id3159084" role="heading" level="2" l10n="U"
392oldref="218">INT</paragraph>
370<paragraph xml-lang="en-US" id="hd_id3159084" role="heading" level="2" l10n="U" oldref="218">INT</paragraph>
393<paragraph xml-lang="en-US" id="par_id3158441" role="paragraph" l10n="U" oldref="219"><ahelp hid="HID_FUNC_GANZZAHL">Rounds a number down to the nearest integer.</ahelp></paragraph>
371<paragraph xml-lang="en-US" id="par_id3158441" role="paragraph" l10n="U" oldref="219"><ahelp hid="HID_FUNC_GANZZAHL">Rounds a number down to the nearest integer.</ahelp></paragraph>
394<paragraph xml-lang="en-US" id="hd_id3146132" role="heading" level="3" l10n="U"
395oldref="220">Syntax</paragraph>
372<paragraph xml-lang="en-US" id="hd_id3146132" role="heading" level="3" l10n="U" oldref="220">Syntax</paragraph>
396<paragraph xml-lang="en-US" id="par_id3156146" role="code" l10n="U" oldref="221">INT(Number)</paragraph>
397<paragraph xml-lang="en-US" id="par_id3154117" role="paragraph" l10n="CHG" oldref="222">Returns <emph>Number</emph> rounded down to the nearest integer.</paragraph>
398<paragraph xml-lang="en-US" id="par_id153508" role="paragraph" l10n="NEW">Negative numbers round down to the integer below.</paragraph>
373<paragraph xml-lang="en-US" id="par_id3156146" role="code" l10n="U" oldref="221">INT(Number)</paragraph>
374<paragraph xml-lang="en-US" id="par_id3154117" role="paragraph" l10n="CHG" oldref="222">Returns <emph>Number</emph> rounded down to the nearest integer.</paragraph>
375<paragraph xml-lang="en-US" id="par_id153508" role="paragraph" l10n="NEW">Negative numbers round down to the integer below.</paragraph>
399<paragraph xml-lang="en-US" id="hd_id3155118" role="heading" level="3" l10n="U"
400oldref="223">Example</paragraph>
376<paragraph xml-lang="en-US" id="hd_id3155118" role="heading" level="3" l10n="U" oldref="223">Example</paragraph>
401<paragraph xml-lang="en-US" id="par_id3156267" role="paragraph" l10n="CHG" oldref="224">
402<item type="input">=INT(5.7)</item> returns 5.</paragraph>
403<paragraph xml-lang="en-US" id="par_id3147323" role="paragraph" l10n="CHG" oldref="225">
404<item type="input">=INT(-1.3)</item> returns -2.</paragraph><comment>see also TRUNC, ROUND, ROUNDDOWN, ROUNDUP,
405CEILING, FLOOR, EVEN, ODD, MROUND, </comment>
406</section>
407<section id="Section44">
408<bookmark xml-lang="en-US" branch="index" id="bm_id3150938"><bookmark_value>EVEN function</bookmark_value>
409<bookmark_value>numbers;rounding up/down to even integers</bookmark_value>
410<bookmark_value>rounding;up/down to even integers</bookmark_value>
411</bookmark><comment>mw added two entries</comment>
412<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949" localize="false"/>
377<paragraph xml-lang="en-US" id="par_id3156267" role="paragraph" l10n="CHG" oldref="224">
378<item type="input">=INT(5.7)</item> returns 5.</paragraph>
379<paragraph xml-lang="en-US" id="par_id3147323" role="paragraph" l10n="CHG" oldref="225">
380<item type="input">=INT(-1.3)</item> returns -2.</paragraph><comment>see also TRUNC, ROUND, ROUNDDOWN, ROUNDUP,
381CEILING, FLOOR, EVEN, ODD, MROUND, </comment>
382</section>
383<section id="Section44">
384<bookmark xml-lang="en-US" branch="index" id="bm_id3150938"><bookmark_value>EVEN function</bookmark_value>
385<bookmark_value>numbers;rounding up/down to even integers</bookmark_value>
386<bookmark_value>rounding;up/down to even integers</bookmark_value>
387</bookmark><comment>mw added two entries</comment>
388<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949" localize="false"/>
413<paragraph xml-lang="en-US" id="hd_id3150938" role="heading" level="2" l10n="U"
414oldref="227">EVEN</paragraph>
389<paragraph xml-lang="en-US" id="hd_id3150938" role="heading" level="2" l10n="U" oldref="227">EVEN</paragraph>
415<paragraph xml-lang="en-US" id="par_id3149988" role="paragraph" l10n="CHG" oldref="228"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the next even integer and a negative number down to the next even integer.</ahelp></paragraph>
390<paragraph xml-lang="en-US" id="par_id3149988" role="paragraph" l10n="CHG" oldref="228"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the next even integer and a negative number down to the next even integer.</ahelp></paragraph>
416<paragraph xml-lang="en-US" id="hd_id3148401" role="heading" level="3" l10n="U"
417oldref="229">Syntax</paragraph>
391<paragraph xml-lang="en-US" id="hd_id3148401" role="heading" level="3" l10n="U" oldref="229">Syntax</paragraph>
418<paragraph xml-lang="en-US" id="par_id3150830" role="code" l10n="U" oldref="230">EVEN(Number)</paragraph>
419<paragraph xml-lang="en-US" id="par_id3153350" role="paragraph" l10n="CHG" oldref="231"> Returns <emph>Number</emph> rounded to the next even integer up, away from zero. </paragraph>
392<paragraph xml-lang="en-US" id="par_id3150830" role="code" l10n="U" oldref="230">EVEN(Number)</paragraph>
393<paragraph xml-lang="en-US" id="par_id3153350" role="paragraph" l10n="CHG" oldref="231"> Returns <emph>Number</emph> rounded to the next even integer up, away from zero. </paragraph>
420<paragraph xml-lang="en-US" id="hd_id3155508" role="heading" level="3" l10n="U"
421oldref="232">Examples</paragraph>
394<paragraph xml-lang="en-US" id="hd_id3155508" role="heading" level="3" l10n="U" oldref="232">Examples</paragraph>
422<paragraph xml-lang="en-US" id="par_id3154361" role="paragraph" l10n="CHG" oldref="233">
423<item type="input">=EVEN(2.3)</item> returns 4.</paragraph>
424<paragraph xml-lang="en-US" id="par_id8477736" role="paragraph" l10n="NEW">
425<item type="input">=EVEN(2)</item> returns 2.</paragraph>
426<paragraph xml-lang="en-US" id="par_id159611" role="paragraph" l10n="NEW">
427<item type="input">=EVEN(0)</item> returns 0.</paragraph>
428<paragraph xml-lang="en-US" id="par_id6097598" role="paragraph" l10n="NEW">
429<item type="input">=EVEN(-0.5)</item> returns -2.</paragraph><comment>see also CEILING, FLOOR, ODD, MROUND,
430INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
431</section>
432<section id="Section43">
433<bookmark xml-lang="en-US" branch="index" id="bm_id3147356"><bookmark_value>GCD function</bookmark_value>
434<bookmark_value>greatest common divisor</bookmark_value>
435</bookmark><comment>mw added one entry</comment>
436<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737" localize="false"/>
437<paragraph xml-lang="en-US" id="hd_id3147356" role="heading" level="2" l10n="U"
438oldref="237">GCD</paragraph>
439<paragraph xml-lang="en-US" id="par_id3152465" role="paragraph" l10n="U" oldref="238"><ahelp hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more integers.</ahelp></paragraph>
440<paragraph xml-lang="en-US" id="par_id2769249" role="paragraph" l10n="NEW">The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers.</paragraph>
395<paragraph xml-lang="en-US" id="par_id3154361" role="paragraph" l10n="CHG" oldref="233">
396<item type="input">=EVEN(2.3)</item> returns 4.</paragraph>
397<paragraph xml-lang="en-US" id="par_id8477736" role="paragraph" l10n="NEW">
398<item type="input">=EVEN(2)</item> returns 2.</paragraph>
399<paragraph xml-lang="en-US" id="par_id159611" role="paragraph" l10n="NEW">
400<item type="input">=EVEN(0)</item> returns 0.</paragraph>
401<paragraph xml-lang="en-US" id="par_id6097598" role="paragraph" l10n="NEW">
402<item type="input">=EVEN(-0.5)</item> returns -2.</paragraph><comment>see also CEILING, FLOOR, ODD, MROUND,
403INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment>
404</section>
405<section id="Section43">
406<bookmark xml-lang="en-US" branch="index" id="bm_id3147356"><bookmark_value>GCD function</bookmark_value>
407<bookmark_value>greatest common divisor</bookmark_value>
408</bookmark><comment>mw added one entry</comment>
409<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737" localize="false"/>
410<paragraph xml-lang="en-US" id="hd_id3147356" role="heading" level="2" l10n="U"
411oldref="237">GCD</paragraph>
412<paragraph xml-lang="en-US" id="par_id3152465" role="paragraph" l10n="U" oldref="238"><ahelp hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more integers.</ahelp></paragraph>
413<paragraph xml-lang="en-US" id="par_id2769249" role="paragraph" l10n="NEW">The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers.</paragraph>
441<paragraph xml-lang="en-US" id="hd_id3150643" role="heading" level="3" l10n="U"
442oldref="239">Syntax</paragraph>
414<paragraph xml-lang="en-US" id="hd_id3150643" role="heading" level="3" l10n="U" oldref="239">Syntax</paragraph>
443<paragraph xml-lang="en-US" id="par_id3154524" role="code" l10n="U" oldref="240">GCD(Integer1; Integer2; ...; Integer30)</paragraph>
444<paragraph xml-lang="en-US" id="par_id3149340" role="paragraph" l10n="U" oldref="241"><emph>Integer1 To 30</emph> are up to 30 integers whose greatest common divisor is to be calculated.</paragraph>
415<paragraph xml-lang="en-US" id="par_id3154524" role="code" l10n="U" oldref="240">GCD(Integer1; Integer2; ...; Integer30)</paragraph>
416<paragraph xml-lang="en-US" id="par_id3149340" role="paragraph" l10n="U" oldref="241"><emph>Integer1 To 30</emph> are up to 30 integers whose greatest common divisor is to be calculated.</paragraph>
445<paragraph xml-lang="en-US" id="hd_id3147317" role="heading" level="3" l10n="U"
446oldref="242">Example</paragraph>
417<paragraph xml-lang="en-US" id="hd_id3147317" role="heading" level="3" l10n="U" oldref="242">Example</paragraph>
447<paragraph xml-lang="en-US" id="par_id3151285" role="paragraph" l10n="CHG" oldref="243">
448<item type="input">=GCD(16;32;24) </item>gives the result 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder.</paragraph>
449<paragraph xml-lang="en-US" id="par_id1604663" role="paragraph" l10n="NEW">
450<item type="input">=GCD(B1:B3)</item> where cells B1, B2, B3 contain <item type="input">9</item>, <item type="input">12</item>, <item type="input">9</item> gives 3.</paragraph>
451</section>
452<section id="Section42">
453<bookmark xml-lang="en-US" branch="index" id="bm_id3151221"><bookmark_value>GCD_ADD function</bookmark_value>
454</bookmark>
455<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/>
456<paragraph xml-lang="en-US" id="hd_id3151221" role="heading" level="2" l10n="E"
457oldref="677">GCD_ADD</paragraph>
458<paragraph xml-lang="en-US" id="par_id3153257" role="paragraph" l10n="U" oldref="678"><ahelp hid="HID_AAI_FUNC_GCD"> The result is the greatest common divisor of a list of numbers.</ahelp></paragraph>
459<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
460<paragraph xml-lang="en-US" id="hd_id3147548" role="heading" level="3" l10n="U"
461oldref="679">Syntax</paragraph>
462<paragraph xml-lang="en-US" id="par_id3156205" role="code" l10n="U" oldref="680">GCD_ADD(Number(s))</paragraph>
463<paragraph xml-lang="en-US" id="par_id3145150" role="paragraph" l10n="U" oldref="681"><emph>Number(s)</emph> is a list of up to 30 numbers.</paragraph>
418<paragraph xml-lang="en-US" id="par_id3151285" role="paragraph" l10n="CHG" oldref="243">
419<item type="input">=GCD(16;32;24) </item>gives the result 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder.</paragraph>
420<paragraph xml-lang="en-US" id="par_id1604663" role="paragraph" l10n="NEW">
421<item type="input">=GCD(B1:B3)</item> where cells B1, B2, B3 contain <item type="input">9</item>, <item type="input">12</item>, <item type="input">9</item> gives 3.</paragraph>
422</section>
423<section id="Section42">
424<bookmark xml-lang="en-US" branch="index" id="bm_id3151221"><bookmark_value>GCD_ADD function</bookmark_value>
425</bookmark>
426<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/>
427<paragraph xml-lang="en-US" id="hd_id3151221" role="heading" level="2" l10n="E"
428oldref="677">GCD_ADD</paragraph>
429<paragraph xml-lang="en-US" id="par_id3153257" role="paragraph" l10n="U" oldref="678"><ahelp hid="HID_AAI_FUNC_GCD"> The result is the greatest common divisor of a list of numbers.</ahelp></paragraph>
430<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
431<paragraph xml-lang="en-US" id="hd_id3147548" role="heading" level="3" l10n="U"
432oldref="679">Syntax</paragraph>
433<paragraph xml-lang="en-US" id="par_id3156205" role="code" l10n="U" oldref="680">GCD_ADD(Number(s))</paragraph>
434<paragraph xml-lang="en-US" id="par_id3145150" role="paragraph" l10n="U" oldref="681"><emph>Number(s)</emph> is a list of up to 30 numbers.</paragraph>
464<paragraph xml-lang="en-US" id="hd_id3150239" role="heading" level="3" l10n="U"
465oldref="682">Example</paragraph>
435<paragraph xml-lang="en-US" id="hd_id3150239" role="heading" level="3" l10n="U" oldref="682">Example</paragraph>
466<paragraph xml-lang="en-US" id="par_id3159192" role="paragraph" l10n="U" oldref="683">
467<item type="input">=GCD_ADD(5;15;25)</item> returns 5.</paragraph>
468</section>
469<section id="Section41">
470<bookmark xml-lang="en-US" branch="index" id="bm_id3156048"><bookmark_value>ISEVEN function</bookmark_value>
471<bookmark_value>even integers</bookmark_value>
472</bookmark><comment>mw added one entry</comment>
473<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTGERADE" id="bm_id3149430" localize="false"/>
436<paragraph xml-lang="en-US" id="par_id3159192" role="paragraph" l10n="U" oldref="683">
437<item type="input">=GCD_ADD(5;15;25)</item> returns 5.</paragraph>
438</section>
439<section id="Section41">
440<bookmark xml-lang="en-US" branch="index" id="bm_id3156048"><bookmark_value>ISEVEN function</bookmark_value>
441<bookmark_value>even integers</bookmark_value>
442</bookmark><comment>mw added one entry</comment>
443<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTGERADE" id="bm_id3149430" localize="false"/>
474<paragraph xml-lang="en-US" id="hd_id3156048" role="heading" level="2" l10n="U"
475oldref="245">ISEVEN<comment>link from Information cat</comment></paragraph>
444<paragraph xml-lang="en-US" id="hd_id3156048" role="heading" level="2" l10n="U" oldref="245">ISEVEN<comment>link from Information cat</comment></paragraph>
476<paragraph xml-lang="en-US" id="par_id3149169" role="paragraph" l10n="U" oldref="246"><ahelp hid="HID_FUNC_ISTGERADE">Returns TRUE if the value is an even integer, or FALSE if the value is odd.</ahelp></paragraph>
445<paragraph xml-lang="en-US" id="par_id3149169" role="paragraph" l10n="U" oldref="246"><ahelp hid="HID_FUNC_ISTGERADE">Returns TRUE if the value is an even integer, or FALSE if the value is odd.</ahelp></paragraph>
477<paragraph xml-lang="en-US" id="hd_id3146928" role="heading" level="3" l10n="U"
478oldref="247">Syntax</paragraph>
446<paragraph xml-lang="en-US" id="hd_id3146928" role="heading" level="3" l10n="U" oldref="247">Syntax</paragraph>
479<paragraph xml-lang="en-US" id="par_id3151203" role="code" l10n="U" oldref="248">ISEVEN(Value)</paragraph>
480<paragraph xml-lang="en-US" id="par_id3150491" role="paragraph" l10n="U" oldref="249"><emph>Value</emph> is the value to be checked.</paragraph>
481<paragraph xml-lang="en-US" id="par_id3445844" role="paragraph" l10n="NEW">If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored.</paragraph>
447<paragraph xml-lang="en-US" id="par_id3151203" role="code" l10n="U" oldref="248">ISEVEN(Value)</paragraph>
448<paragraph xml-lang="en-US" id="par_id3150491" role="paragraph" l10n="U" oldref="249"><emph>Value</emph> is the value to be checked.</paragraph>
449<paragraph xml-lang="en-US" id="par_id3445844" role="paragraph" l10n="NEW">If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored.</paragraph>
482<paragraph xml-lang="en-US" id="hd_id3154136" role="heading" level="3" l10n="U"
483oldref="250">Example</paragraph>
450<paragraph xml-lang="en-US" id="hd_id3154136" role="heading" level="3" l10n="U" oldref="250">Example</paragraph>
484<paragraph xml-lang="en-US" id="par_id3163813" role="paragraph" l10n="CHG" oldref="251">
485<item type="input">=ISEVEN(48)</item> returns TRUE</paragraph>
486<paragraph xml-lang="en-US" id="par_id8378856" role="paragraph" l10n="NEW">
487<item type="input">=ISEVEN(33)</item> returns FALSE</paragraph>
488<paragraph xml-lang="en-US" id="par_id7154759" role="paragraph" l10n="NEW">
489<item type="input">=ISEVEN(0)</item> returns TRUE</paragraph>
490<paragraph xml-lang="en-US" id="par_id1912289" role="paragraph" l10n="NEW">
491<item type="input">=ISEVEN(-2.1)</item> returns TRUE</paragraph>
492<paragraph xml-lang="en-US" id="par_id5627307" role="paragraph" l10n="NEW">
493<item type="input">=ISEVEN(3.999)</item> returns FALSE</paragraph><comment>see also ISODD </comment>
494</section>
495<section id="Section40">
496<bookmark xml-lang="en-US" branch="index" id="bm_id3156034"><bookmark_value>ISODD function</bookmark_value>
497<bookmark_value>odd integers</bookmark_value>
498</bookmark><comment>mw added one entry</comment>
499<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTUNGERADE" id="bm_id3149298" localize="false"/>
451<paragraph xml-lang="en-US" id="par_id3163813" role="paragraph" l10n="CHG" oldref="251">
452<item type="input">=ISEVEN(48)</item> returns TRUE</paragraph>
453<paragraph xml-lang="en-US" id="par_id8378856" role="paragraph" l10n="NEW">
454<item type="input">=ISEVEN(33)</item> returns FALSE</paragraph>
455<paragraph xml-lang="en-US" id="par_id7154759" role="paragraph" l10n="NEW">
456<item type="input">=ISEVEN(0)</item> returns TRUE</paragraph>
457<paragraph xml-lang="en-US" id="par_id1912289" role="paragraph" l10n="NEW">
458<item type="input">=ISEVEN(-2.1)</item> returns TRUE</paragraph>
459<paragraph xml-lang="en-US" id="par_id5627307" role="paragraph" l10n="NEW">
460<item type="input">=ISEVEN(3.999)</item> returns FALSE</paragraph><comment>see also ISODD </comment>
461</section>
462<section id="Section40">
463<bookmark xml-lang="en-US" branch="index" id="bm_id3156034"><bookmark_value>ISODD function</bookmark_value>
464<bookmark_value>odd integers</bookmark_value>
465</bookmark><comment>mw added one entry</comment>
466<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTUNGERADE" id="bm_id3149298" localize="false"/>
500<paragraph xml-lang="en-US" id="hd_id3156034" role="heading" level="2" l10n="U"
501oldref="255">ISODD<comment>link from Information cat</comment></paragraph>
467<paragraph xml-lang="en-US" id="hd_id3156034" role="heading" level="2" l10n="U" oldref="255">ISODD<comment>link from Information cat</comment></paragraph>
502<paragraph xml-lang="en-US" id="par_id3155910" role="paragraph" l10n="U" oldref="256"><ahelp hid="HID_FUNC_ISTUNGERADE">Returns TRUE if the value is odd, or FALSE if the number is even.</ahelp></paragraph>
468<paragraph xml-lang="en-US" id="par_id3155910" role="paragraph" l10n="U" oldref="256"><ahelp hid="HID_FUNC_ISTUNGERADE">Returns TRUE if the value is odd, or FALSE if the number is even.</ahelp></paragraph>
503<paragraph xml-lang="en-US" id="hd_id3151006" role="heading" level="3" l10n="U"
504oldref="257">Syntax</paragraph>
469<paragraph xml-lang="en-US" id="hd_id3151006" role="heading" level="3" l10n="U" oldref="257">Syntax</paragraph>
505<paragraph xml-lang="en-US" id="par_id3151375" role="code" l10n="U" oldref="258">ISODD(value)</paragraph>
506<paragraph xml-lang="en-US" id="par_id3155139" role="paragraph" l10n="U" oldref="259"><emph>Value</emph> is the value to be checked.</paragraph>
507<paragraph xml-lang="en-US" id="par_id9027680" role="paragraph" l10n="NEW">If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored.</paragraph>
470<paragraph xml-lang="en-US" id="par_id3151375" role="code" l10n="U" oldref="258">ISODD(value)</paragraph>
471<paragraph xml-lang="en-US" id="par_id3155139" role="paragraph" l10n="U" oldref="259"><emph>Value</emph> is the value to be checked.</paragraph>
472<paragraph xml-lang="en-US" id="par_id9027680" role="paragraph" l10n="NEW">If Value is not an integer any digits after the decimal point are ignored. The sign of Value is also ignored.</paragraph>
508<paragraph xml-lang="en-US" id="hd_id3163723" role="heading" level="3" l10n="U"
509oldref="260">Example</paragraph>
473<paragraph xml-lang="en-US" id="hd_id3163723" role="heading" level="3" l10n="U" oldref="260">Example</paragraph>
510<paragraph xml-lang="en-US" id="par_id3155345" role="paragraph" l10n="CHG" oldref="261">
511<item type="input">=ISODD(33)</item> returns TRUE</paragraph>
512<paragraph xml-lang="en-US" id="par_id9392986" role="paragraph" l10n="NEW">
513<item type="input">=ISODD(48)</item> returns FALSE</paragraph>
514<paragraph xml-lang="en-US" id="par_id5971251" role="paragraph" l10n="NEW">
515<item type="input">=ISODD(3.999)</item> returns TRUE</paragraph>
516<paragraph xml-lang="en-US" id="par_id4136478" role="paragraph" l10n="NEW">
517<item type="input">=ISODD(-3.1)</item> returns TRUE</paragraph><comment>see also ISEVEN</comment>

--- 494 unchanged lines hidden (view full) ---

1012<paragraph xml-lang="en-US" id="hd_id3152110" role="heading" level="3" l10n="U"
1013oldref="443">Example</paragraph>
1014<paragraph xml-lang="en-US" id="par_id3152148" role="paragraph" l10n="CHG" oldref="626">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"&lt;0")</item>
1015</paragraph>
1016<paragraph xml-lang="en-US" id="par_id6670125" role="paragraph" l10n="NEW">
1017<item type="input">=SUMIF(A1:A10;"&gt;0";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are &gt;0.</paragraph>
1018<paragraph xml-lang="en-US" id="par_id6062196" role="paragraph" l10n="NEW">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph>
1019</section>
474<paragraph xml-lang="en-US" id="par_id3155345" role="paragraph" l10n="CHG" oldref="261">
475<item type="input">=ISODD(33)</item> returns TRUE</paragraph>
476<paragraph xml-lang="en-US" id="par_id9392986" role="paragraph" l10n="NEW">
477<item type="input">=ISODD(48)</item> returns FALSE</paragraph>
478<paragraph xml-lang="en-US" id="par_id5971251" role="paragraph" l10n="NEW">
479<item type="input">=ISODD(3.999)</item> returns TRUE</paragraph>
480<paragraph xml-lang="en-US" id="par_id4136478" role="paragraph" l10n="NEW">
481<item type="input">=ISODD(-3.1)</item> returns TRUE</paragraph><comment>see also ISEVEN</comment>

--- 494 unchanged lines hidden (view full) ---

976<paragraph xml-lang="en-US" id="hd_id3152110" role="heading" level="3" l10n="U"
977oldref="443">Example</paragraph>
978<paragraph xml-lang="en-US" id="par_id3152148" role="paragraph" l10n="CHG" oldref="626">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"&lt;0")</item>
979</paragraph>
980<paragraph xml-lang="en-US" id="par_id6670125" role="paragraph" l10n="NEW">
981<item type="input">=SUMIF(A1:A10;"&gt;0";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are &gt;0.</paragraph>
982<paragraph xml-lang="en-US" id="par_id6062196" role="paragraph" l10n="NEW">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph>
983</section>
984<section id="Section15">
985<bookmark xml-lang="en-US" branch="index" id="bm_id3151957K"><bookmark_value>SUMIFS function</bookmark_value>
986<bookmark_value>adding;specified numbers</bookmark_value>
987</bookmark><comment>kschenk added one entry</comment>
988<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWNRNG" id="bm_id3151969K" localize="false"/>
989<paragraph xml-lang="en-US" id="hd_id3151957K" role="heading" level="2" l10n="U"
990oldref="436">SUMIFS</paragraph>
991<paragraph xml-lang="en-US" id="par_id3151986K" role="paragraph" l10n="U" ><ahelp hid="HID_FUNC_SUMMEWNRNG">Sum the values of cells in a range that meet multiple criteria in multiple ranges.</ahelp>
992</paragraph>
993<embed href="text/shared/00/00000001.xhp#regulaer"/>
994<paragraph xml-lang="en-US" id="hd_id3152015K" role="heading" level="3" l10n="U">Syntax</paragraph>
995<paragraph xml-lang="en-US" id="par_id3152028K" role="code" l10n="U">SUMIFS( Reference R ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph>
996<paragraph xml-lang="en-US" id="par_id3152043K" role="paragraph" l10n="U">Sums the value of cells in range R that meet the Criterion C1 in the reference range R1, and the Criterion C2 in the reference range R2, and so on. </paragraph>
997<paragraph xml-lang="en-US" id="par_id3152062K" role="paragraph" l10n="CHG" >A <emph>Criterion</emph> is a single cell Reference, Number or Text. If the criterion is written into the formula, it has to be surrounded by double quotes.</paragraph>
998<paragraph xml-lang="en-US" id="par_id3152083K" role="paragraph" l10n="U">All <emph>Reference</emph> ranges shall have the same dimension and size, else an Error is returned.</paragraph>
999<!--<paragraph xml-lang="en-US" id="par_id8347422K" role="note" l10n="NEW">SUMIFS supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</paragraph>-->
1000<paragraph xml-lang="en-US" id="hd_id3152110K" role="heading" level="3" l10n="U"
1001oldref="443">Example</paragraph>
1002<paragraph xml-lang="en-US" id="par_id3152148K" role="paragraph" l10n="CHG">Sum up cells in range A1:10 if the entires in B1:B10 are positive, and the entries in D1:D10 are the letter "A": <item type="input">=SUMIFS(A1:A10;B1:B10;"&gt;0";D1:D10;"A")</item>
1003</paragraph>
1004<paragraph xml-lang="en-US" id="par_id6062196K" role="paragraph" l10n="NEW">See COUNTIFS() for some more syntax examples that can be used with SUMIFS().</paragraph>
1005</section>
1006
1020<section id="Section14">
1021<bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value>
1022</bookmark>
1023<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/>
1024<paragraph xml-lang="en-US" id="hd_id3152195" role="heading" level="2" l10n="U"
1025oldref="446">TAN</paragraph>
1026<paragraph xml-lang="en-US" id="par_id3152224" role="paragraph" l10n="CHG" oldref="447"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph>
1027<paragraph xml-lang="en-US" id="hd_id3152242" role="heading" level="3" l10n="U"

--- 377 unchanged lines hidden (view full) ---

1405<item type="input">=COUNTIF(A1:A10;"&gt;=2006") </item>- this returns 4</paragraph>
1406<paragraph xml-lang="en-US" id="par_id2118594" role="paragraph" l10n="NEW">
1407<item type="input">=COUNTIF(A1:A10;"&lt;"&amp;B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6</paragraph>
1408<paragraph xml-lang="en-US" id="par_id166020" role="paragraph" l10n="NEW">
1409<item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">&gt;2006</item> counts the number of cells in the range A1:A10 which are &gt;2006 </paragraph>
1410<paragraph xml-lang="en-US" id="par_id6386913" role="paragraph" l10n="NEW">To count only negative numbers: <item type="input">=COUNTIF(A1:A10;"&lt;0")</item>
1411</paragraph>
1412</section>
1007<section id="Section14">
1008<bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value>
1009</bookmark>
1010<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/>
1011<paragraph xml-lang="en-US" id="hd_id3152195" role="heading" level="2" l10n="U"
1012oldref="446">TAN</paragraph>
1013<paragraph xml-lang="en-US" id="par_id3152224" role="paragraph" l10n="CHG" oldref="447"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph>
1014<paragraph xml-lang="en-US" id="hd_id3152242" role="heading" level="3" l10n="U"

--- 377 unchanged lines hidden (view full) ---

1392<item type="input">=COUNTIF(A1:A10;"&gt;=2006") </item>- this returns 4</paragraph>
1393<paragraph xml-lang="en-US" id="par_id2118594" role="paragraph" l10n="NEW">
1394<item type="input">=COUNTIF(A1:A10;"&lt;"&amp;B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6</paragraph>
1395<paragraph xml-lang="en-US" id="par_id166020" role="paragraph" l10n="NEW">
1396<item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">&gt;2006</item> counts the number of cells in the range A1:A10 which are &gt;2006 </paragraph>
1397<paragraph xml-lang="en-US" id="par_id6386913" role="paragraph" l10n="NEW">To count only negative numbers: <item type="input">=COUNTIF(A1:A10;"&lt;0")</item>
1398</paragraph>
1399</section>
1400<section id="Section63">
1401<bookmark xml-lang="en-US" branch="index" id="bm_id3164897K"><bookmark_value>COUNTIFS function</bookmark_value>
1402<bookmark_value>counting;specified cells</bookmark_value>
1403</bookmark>
1404<comment>kschenk added one entry</comment>
1405<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909K" localize="false"/>
1406<paragraph xml-lang="en-US" id="hd_id3164897K" role="heading" level="2" l10n="U">COUNTIFS</paragraph>
1407<paragraph xml-lang="en-US" id="par_id3164926K" role="paragraph" l10n="CHG"><ahelp hid="HID_FUNC_ZAEHLENWNRNG">Count the number of cells that meet multiple criteria in multiple ranges.</ahelp></paragraph>
1408<embed href="text/shared/00/00000001.xhp#regulaer"/>
1409<paragraph xml-lang="en-US" id="hd_id3164953K" role="heading" level="3" l10n="U">Syntax</paragraph>
1410<paragraph xml-lang="en-US" id="par_id3164967K" role="code" l10n="U" >COUNTIFS( Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph>
1411<paragraph xml-lang="en-US" id="par_id3164980K" role="paragraph" l10n="U" ><emph>Reference R1</emph> is the range to which the <emph>Criterion C1</emph>applies. <emph>Reference R2</emph> is the range to which the <emph>Criterion C2</emph>applies, and so on.</paragraph>
1412<paragraph xml-lang="en-US" id="par_id3165000K" role="paragraph" l10n="CHG">All <emph>Reference </emph> ranges shall have the same dimension and size, else an Error is returned. <emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes.</paragraph>
1413<paragraph xml-lang="en-US" id="hd_id3165037K" role="heading" level="3" l10n="U"
1414oldref="553">Examples:</paragraph>
1415<paragraph xml-lang="en-US" id="par_id3166505K" role="paragraph" l10n="CHG">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. B1:B10 is a cell range containing the numbers
1416<item type="input">2007</item> to <item type="input">2016</item>:</paragraph>
1417<paragraph xml-lang="en-US" id="par_id3581652K" role="paragraph" l10n="NEW">
1418<item type="input">=COUNTIFS(A1:A10;2006;B1:B10;2014)</item> - this returns 2</paragraph>
1419<paragraph xml-lang="en-US" id="par_id5169225K" role="paragraph" l10n="NEW">
1420<item type="input">=COUNTIFS(A1:A10;"&gt;=2006";B1:B10;"&gt;=2006") </item>- this returns 14</paragraph>
1421</section>
1413</sort>
1414<section id="relatedtopics">
1415<embed href="text/scalc/01/04060100.xhp#drking"/>
1416</section>
1417</body>
1418</helpdocument>
1422</sort>
1423<section id="relatedtopics">
1424<embed href="text/scalc/01/04060100.xhp#drking"/>
1425</section>
1426</body>
1427</helpdocument>