diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060106.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060106.xhp | 128 |
1 files changed, 64 insertions, 64 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp index e79c3224b7..6e7ef0f804 100644 --- a/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/helpcontent2/source/text/scalc/01/04060106.xhp @@ -51,7 +51,7 @@ <bookmark_value>absolute values</bookmark_value> <bookmark_value>values;absolute</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ABS" id="bm_id3150695" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABS" id="bm_id3150695" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3146944" role="heading" level="2" l10n="U" oldref="33">ABS</paragraph> <paragraph xml-lang="en-US" id="par_id3154546" role="paragraph" l10n="U" oldref="34"><ahelp hid="HID_FUNC_ABS">Returns the absolute value of a number.</ahelp></paragraph> @@ -73,7 +73,7 @@ oldref="38">Example</paragraph> <bookmark_value>counting;empty cells</bookmark_value> <bookmark_value>empty cells;counting</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ANZAHLLEEREZELLEN" id="bm_id3149730" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3150896" role="heading" level="2" l10n="U" oldref="42">COUNTBLANK</paragraph> <paragraph xml-lang="en-US" id="par_id3155260" role="paragraph" l10n="CHG" oldref="43"><ahelp hid="HID_FUNC_ANZAHLLEEREZELLEN">Returns the number of empty cells.</ahelp></paragraph> @@ -89,7 +89,7 @@ oldref="47">Example</paragraph> <section id="Section61"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153114"><bookmark_value>ACOS function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCCOS" id="bm_id3155952" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOS" id="bm_id3155952" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153114" role="heading" level="2" l10n="U" oldref="50">ACOS</paragraph> <paragraph xml-lang="en-US" id="par_id3145163" role="paragraph" l10n="CHG" oldref="51"><ahelp hid="HID_FUNC_ARCCOS">Returns the inverse trigonometric cosine of a number.</ahelp></paragraph> @@ -108,7 +108,7 @@ oldref="55">Example</paragraph> <section id="Section60"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145355"><bookmark_value>ACOSH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCOSHYP" id="bm_id3148386" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOSHYP" id="bm_id3148386" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3145355" role="heading" level="2" l10n="U" oldref="60">ACOSH</paragraph> <paragraph xml-lang="en-US" id="par_id3157993" role="paragraph" l10n="U" oldref="61"><ahelp hid="HID_FUNC_ARCOSHYP">Returns the inverse hyperbolic cosine of a number.</ahelp></paragraph> @@ -127,7 +127,7 @@ oldref="65">Example</paragraph> <section id="Section59"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149027"><bookmark_value>ACOT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCCOT" id="bm_id3154634" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCCOT" id="bm_id3154634" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3149027" role="heading" level="2" l10n="U" oldref="70">ACOT</paragraph> <paragraph xml-lang="en-US" id="par_id3155818" role="paragraph" l10n="CHG" oldref="71"><ahelp hid="HID_FUNC_ARCCOT">Returns the inverse cotangent (the arccotangent) of the given number.</ahelp></paragraph> @@ -146,7 +146,7 @@ oldref="75">Example</paragraph> <section id="Section58"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148426"><bookmark_value>ACOTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCOTHYP" id="bm_id3149777" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCOTHYP" id="bm_id3149777" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3148426" role="heading" level="2" l10n="U" oldref="80">ACOTH</paragraph> <paragraph xml-lang="en-US" id="par_id3147478" role="paragraph" l10n="U" oldref="81"><ahelp hid="HID_FUNC_ARCOTHYP">Returns the inverse hyperbolic cotangent of the given number.</ahelp></paragraph> @@ -163,7 +163,7 @@ oldref="85">Example</paragraph> <section id="Section57"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145084"><bookmark_value>ASIN function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCSIN" id="bm_id3149280" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3145084" role="heading" level="2" l10n="U" oldref="90">ASIN</paragraph> <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> @@ -184,7 +184,7 @@ oldref="95">Example</paragraph> <section id="Section56"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151266"><bookmark_value>ASINH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARSINHYP" id="bm_id3145206" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARSINHYP" id="bm_id3145206" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3151266" role="heading" level="2" l10n="U" oldref="100">ASINH</paragraph> <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> @@ -203,7 +203,7 @@ COSH, SINH, TANH, COTH</comment> <section id="Section55"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155996"><bookmark_value>ATAN function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCTAN" id="bm_id3154743" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN" id="bm_id3154743" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155996" role="heading" level="2" l10n="U" oldref="110">ATAN</paragraph> <paragraph xml-lang="en-US" id="par_id3149985" role="paragraph" l10n="CHG" oldref="111"><ahelp hid="HID_FUNC_ARCTAN">Returns the inverse trigonometric tangent of a number.</ahelp></paragraph> @@ -223,7 +223,7 @@ ACOS, ASIN, ATAN2, ACOT </comment> <section id="Section54"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153983"><bookmark_value>ATAN2 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARCTAN2" id="bm_id3159180" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153983" role="heading" level="2" l10n="U" oldref="120">ATAN2</paragraph> <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> @@ -245,7 +245,7 @@ ACOS, ASIN, ATAN, ACOT </comment> <section id="Section53"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155398"><bookmark_value>ATANH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARTANHYP" id="bm_id3154939" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARTANHYP" id="bm_id3154939" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155398" role="heading" level="2" l10n="U" oldref="130">ATANH</paragraph> <paragraph xml-lang="en-US" id="par_id3148829" role="paragraph" l10n="U" oldref="131"><ahelp hid="HID_FUNC_ARTANHYP">Returns the inverse hyperbolic tangent of a number.</ahelp></paragraph> @@ -263,7 +263,7 @@ COSH, SINH, TANH, COTH</comment> <section id="Section52"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153062"><bookmark_value>COS function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_COS" id="bm_id3158408" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COS" id="bm_id3158408" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153062" role="heading" level="2" l10n="U" oldref="149">COS</paragraph> <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> @@ -283,7 +283,7 @@ ACOS, ASIN, ATAN, ATAN2, ACOT </comment> <section id="Section51"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154277"><bookmark_value>COSH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COSHYP" id="bm_id3149158" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154277" role="heading" level="2" l10n="U" oldref="159">COSH</paragraph> <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> @@ -300,7 +300,7 @@ ACOSH, ASINH, ATANH, ACOTH, </comment> <section id="Section50"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152888"><bookmark_value>COT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_COT" id="bm_id3153392" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COT" id="bm_id3153392" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3152888" role="heading" level="2" l10n="U" oldref="169">COT</paragraph> <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> @@ -321,7 +321,7 @@ ACOS, ASIN, ATAN, ATAN2, ACOT </comment> <section id="Section49"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154337"><bookmark_value>COTH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_COTHYP" id="bm_id3148650" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154337" role="heading" level="2" l10n="U" oldref="178">COTH</paragraph> <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> @@ -339,7 +339,7 @@ ACOSH, ASINH, ATANH, ACOTH, </comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3145314"><bookmark_value>DEGREES function</bookmark_value> <bookmark_value>converting;radians, into degrees</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DEG" id="bm_id3153946" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEG" id="bm_id3153946" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3145314" role="heading" level="2" l10n="U" oldref="188">DEGREES</paragraph> <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> @@ -354,7 +354,7 @@ oldref="190">Syntax</paragraph> <section id="Section47"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148698"><bookmark_value>EXP function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EXP" id="bm_id3154625" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EXP" id="bm_id3154625" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3148698" role="heading" level="2" l10n="U" oldref="198">EXP</paragraph> <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> @@ -371,7 +371,7 @@ oldref="203">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3145781"><bookmark_value>FACT function</bookmark_value> <bookmark_value>factorials;numbers</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FAKULTAET" id="bm_id3153886" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FAKULTAET" id="bm_id3153886" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3145781" role="heading" level="2" l10n="U" oldref="208">FACT</paragraph> <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> @@ -393,7 +393,7 @@ oldref="213">Example</paragraph> <bookmark_value>numbers;rounding down to next integer</bookmark_value> <bookmark_value>rounding;down to next integer</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GANZZAHL" id="bm_id3151311" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GANZZAHL" id="bm_id3151311" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3159084" role="heading" level="2" l10n="U" oldref="218">INT</paragraph> <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> @@ -415,7 +415,7 @@ CEILING, FLOOR, EVEN, ODD, MROUND, </comment> <bookmark_value>numbers;rounding up/down to even integers</bookmark_value> <bookmark_value>rounding;up/down to even integers</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GERADE" id="bm_id3150949" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GERADE" id="bm_id3150949" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3150938" role="heading" level="2" l10n="U" oldref="227">EVEN</paragraph> <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> @@ -439,7 +439,7 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3147356"><bookmark_value>GCD function</bookmark_value> <bookmark_value>greatest common divisor</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_GGT" id="bm_id3149737" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GGT" id="bm_id3149737" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3147356" role="heading" level="2" l10n="U" oldref="237">GCD</paragraph> <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> @@ -458,7 +458,7 @@ oldref="242">Example</paragraph> <section id="Section42"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151221"><bookmark_value>GCD_ADD function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3151221" role="heading" level="2" l10n="E" oldref="677">GCD_ADD</paragraph> <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> @@ -476,7 +476,7 @@ oldref="682">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3156048"><bookmark_value>ISEVEN function</bookmark_value> <bookmark_value>even integers</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTGERADE" id="bm_id3149430" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTGERADE" id="bm_id3149430" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3156048" role="heading" level="2" l10n="U" oldref="245">ISEVEN<comment>link from Information cat</comment></paragraph> <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> @@ -502,7 +502,7 @@ oldref="250">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3156034"><bookmark_value>ISODD function</bookmark_value> <bookmark_value>odd integers</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTUNGERADE" id="bm_id3149298" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTUNGERADE" id="bm_id3149298" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3156034" role="heading" level="2" l10n="U" oldref="255">ISODD<comment>link from Information cat</comment></paragraph> <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> @@ -527,7 +527,7 @@ oldref="260">Example</paragraph> <bookmark_value>least common multiples</bookmark_value> <bookmark_value>lowest common multiples</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KGV" id="bm_id3145225" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KGV" id="bm_id3145225" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3145213" role="heading" level="2" l10n="U" oldref="265">LCM</paragraph> <paragraph xml-lang="en-US" id="par_id3146814" role="paragraph" l10n="U" oldref="266"><ahelp hid="HID_FUNC_KGV">Returns the least common multiple of one or more integers.</ahelp></paragraph> @@ -542,7 +542,7 @@ oldref="270">Example</paragraph> <section id="Section38"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154230"><bookmark_value>LCM_ADD function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_LCM" id="bm_id3147222" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154230" role="heading" level="2" l10n="U" oldref="684">LCM_ADD</paragraph> <paragraph xml-lang="en-US" id="par_id3149036" role="paragraph" l10n="U" oldref="685"><ahelp hid="HID_AAI_FUNC_LCM"> The result is the lowest common multiple of a list of numbers.</ahelp></paragraph> @@ -560,7 +560,7 @@ oldref="689">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3155802"><bookmark_value>COMBIN function</bookmark_value> <bookmark_value>number of combinations</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KOMBINATIONEN" id="bm_id3155077" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN" id="bm_id3155077" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155802" role="heading" level="2" l10n="U" oldref="273">COMBIN<comment>should be statistical-->add a link there</comment></paragraph> <paragraph xml-lang="en-US" id="par_id3156172" role="paragraph" l10n="CHG" oldref="274"><ahelp hid="HID_FUNC_KOMBINATIONEN">Returns the number of combinations for elements without repetition.</ahelp></paragraph> @@ -580,7 +580,7 @@ oldref="279">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3150284"><bookmark_value>COMBINA function</bookmark_value> <bookmark_value>number of combinations with repetitions</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KOMBINATIONEN2" id="bm_id3150295" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KOMBINATIONEN2" id="bm_id3150295" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3150284" role="heading" level="2" l10n="U" oldref="282">COMBINA<comment>should be statistical-->add a link there</comment></paragraph> <paragraph xml-lang="en-US" id="par_id3157894" role="paragraph" l10n="CHG" oldref="283"><ahelp hid="HID_FUNC_KOMBINATIONEN2">Returns the number of combinations of a subset of items including repetitions.</ahelp></paragraph> @@ -600,7 +600,7 @@ oldref="288">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3156086"><bookmark_value>TRUNC function</bookmark_value> <bookmark_value>decimal places;cutting off</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_KUERZEN" id="bm_id3157849" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KUERZEN" id="bm_id3157849" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3156086" role="heading" level="2" l10n="U" oldref="291">TRUNC</paragraph> <paragraph xml-lang="en-US" id="par_id3157866" role="paragraph" l10n="CHG" oldref="292"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number by removing decimal places.</ahelp></paragraph> @@ -623,7 +623,7 @@ CEILING, FLOOR, EVEN, ODD, MROUND</comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3153601"><bookmark_value>LN function</bookmark_value> <bookmark_value>natural logarithm</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LN" id="bm_id3153613" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LN" id="bm_id3153613" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153601" role="heading" level="2" l10n="U" oldref="301">LN</paragraph> <paragraph xml-lang="en-US" id="par_id3154974" role="paragraph" l10n="CHG" oldref="302"><ahelp hid="HID_FUNC_LN">Returns the natural logarithm based on the constant e of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> @@ -642,7 +642,7 @@ oldref="306">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3109813"><bookmark_value>LOG function</bookmark_value> <bookmark_value>logarithms</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LOG" id="bm_id3109824" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG" id="bm_id3109824" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3109813" role="heading" level="2" l10n="U" oldref="311">LOG</paragraph> <paragraph xml-lang="en-US" id="par_id3109841" role="paragraph" l10n="U" oldref="312"><ahelp hid="HID_FUNC_LOG">Returns the logarithm of a number to the specified base.</ahelp></paragraph> @@ -662,7 +662,7 @@ oldref="317">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3154187"><bookmark_value>LOG10 function</bookmark_value> <bookmark_value>base-10 logarithm</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_LOG10" id="bm_id3155460" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LOG10" id="bm_id3155460" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154187" role="heading" level="2" l10n="U" oldref="322">LOG10</paragraph> <paragraph xml-lang="en-US" id="par_id3155476" role="paragraph" l10n="U" oldref="323"><ahelp hid="HID_FUNC_LOG10">Returns the base-10 logarithm of a number.</ahelp></paragraph> @@ -679,7 +679,7 @@ oldref="327">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3152518"><bookmark_value>CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3152518" role="heading" level="2" l10n="U" oldref="332">CEILING</paragraph> <paragraph xml-lang="en-US" id="par_id3153422" role="paragraph" l10n="CHG" oldref="558"><ahelp hid="HID_FUNC_OBERGRENZE">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph> @@ -703,7 +703,7 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> <section id="Section30"> <bookmark xml-lang="en-US" branch="index" id="bm_id3157762"><bookmark_value>PI function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PI" id="bm_id3157774" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PI" id="bm_id3157774" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3157762" role="heading" level="2" l10n="U" oldref="343">PI</paragraph> <paragraph xml-lang="en-US" id="par_id3157790" role="paragraph" l10n="CHG" oldref="344"><ahelp hid="HID_FUNC_PI">Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.</ahelp></paragraph> @@ -718,7 +718,7 @@ oldref="347">Example</paragraph> <section id="Section29"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152418"><bookmark_value>MULTINOMIAL function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_MULTINOMIAL" id="bm_id3152429" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL" id="bm_id3152429" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3152418" role="heading" level="2" l10n="U" oldref="635">MULTINOMIAL</paragraph> <paragraph xml-lang="en-US" id="par_id3152454" role="paragraph" l10n="U" oldref="636"><ahelp hid="HID_AAI_FUNC_MULTINOMIAL"> Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp></paragraph> @@ -734,7 +734,7 @@ oldref="640">Example</paragraph> <section id="Section28"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155717"><bookmark_value>POWER function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_POTENZ" id="bm_id3155728" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_POTENZ" id="bm_id3155728" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155717" role="heading" level="2" l10n="U" oldref="350">POWER</paragraph> <paragraph xml-lang="en-US" id="par_id3159495" role="paragraph" l10n="CHG" oldref="351"><ahelp hid="HID_FUNC_POTENZ">Returns a number raised to another number.</ahelp></paragraph> @@ -755,7 +755,7 @@ oldref="356">Example</paragraph> <section id="Section27"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152651"><bookmark_value>SERIESSUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_SERIESSUM" id="bm_id3152662" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SERIESSUM" id="bm_id3152662" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3152651" role="heading" level="2" l10n="U" oldref="642">SERIESSUM</paragraph> <paragraph xml-lang="en-US" id="par_id3152688" role="paragraph" l10n="CHG" oldref="643"><ahelp hid=".">Sums the first terms of a power series.</ahelp></paragraph> @@ -773,7 +773,7 @@ oldref="645">Syntax</paragraph> <bookmark_value>numbers;multiplying</bookmark_value> <bookmark_value>multiplying;numbers</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_PRODUKT" id="bm_id3144397" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_PRODUKT" id="bm_id3144397" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3144386" role="heading" level="2" l10n="U" oldref="361">PRODUCT</paragraph> <paragraph xml-lang="en-US" id="par_id3144414" role="paragraph" l10n="U" oldref="362"><ahelp hid="HID_FUNC_PRODUKT">Multiplies all the numbers given as arguments and returns the product.</ahelp></paragraph> @@ -792,7 +792,7 @@ oldref="366">Example</paragraph> <bookmark_value>square number additions</bookmark_value> <bookmark_value>sums;of square numbers</bookmark_value> </bookmark><comment>mw added two entries</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_QUADRATESUMME" id="bm_id3160351" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_QUADRATESUMME" id="bm_id3160351" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3160340" role="heading" level="2" l10n="U" oldref="369">SUMSQ</paragraph> <paragraph xml-lang="en-US" id="par_id3160368" role="paragraph" l10n="U" oldref="370"><ahelp hid="HID_FUNC_QUADRATESUMME">If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields.</ahelp></paragraph> @@ -808,7 +808,7 @@ oldref="374">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3158247"><bookmark_value>MOD function</bookmark_value> <bookmark_value>remainders of divisions</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_REST" id="bm_id3158259" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_REST" id="bm_id3158259" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3158247" role="heading" level="2" l10n="U" oldref="387">MOD</paragraph> <paragraph xml-lang="en-US" id="par_id3158276" role="paragraph" l10n="CHG" oldref="388"><ahelp hid="HID_FUNC_REST">Returns the remainder when one integer is divided by another.</ahelp></paragraph> @@ -828,7 +828,7 @@ oldref="393">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3144592"><bookmark_value>QUOTIENT function</bookmark_value> <bookmark_value>divisions</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_QUOTIENT" id="bm_id3144603" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_QUOTIENT" id="bm_id3144603" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3144592" role="heading" level="2" l10n="E" oldref="652">QUOTIENT</paragraph> <paragraph xml-lang="en-US" id="par_id3144627" role="paragraph" l10n="CHG" oldref="653"><ahelp hid="HID_AAI_FUNC_QUOTIENT">Returns the integer part of a division operation.</ahelp></paragraph> @@ -846,7 +846,7 @@ oldref="656">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3144702"><bookmark_value>RADIANS function</bookmark_value> <bookmark_value>converting;degrees, into radians</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_RAD" id="bm_id3158008" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RAD" id="bm_id3158008" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3144702" role="heading" level="2" l10n="U" oldref="377">RADIANS</paragraph> <paragraph xml-lang="en-US" id="par_id3158025" role="paragraph" l10n="U" oldref="378"><ahelp hid="HID_FUNC_RAD">Converts degrees to radians.</ahelp></paragraph> @@ -861,7 +861,7 @@ oldref="379">Syntax</paragraph> <section id="Section21"> <bookmark xml-lang="en-US" branch="index" id="bm_id3158121"><bookmark_value>ROUND function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3158121" role="heading" level="2" l10n="U" oldref="398">ROUND</paragraph> <paragraph xml-lang="en-US" id="par_id3158150" role="paragraph" l10n="CHG" oldref="399"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph> @@ -887,7 +887,7 @@ CEILING, FLOOR, EVEN, ODD, MROUND</comment> <section id="Section20"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145991"><bookmark_value>ROUNDDOWN function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ABRUNDEN" id="bm_id3146003" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ABRUNDEN" id="bm_id3146003" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3145991" role="heading" level="2" l10n="U" oldref="24">ROUNDDOWN</paragraph> <paragraph xml-lang="en-US" id="par_id3146020" role="paragraph" l10n="CHG" oldref="25"><ahelp hid="HID_FUNC_ABRUNDEN">Rounds a number down, toward zero, to a certain precision.</ahelp></paragraph> @@ -911,7 +911,7 @@ CEILING, FLOOR, EVEN, ODD, MROUND</comment> <section id="Section19"> <bookmark xml-lang="en-US" branch="index" id="bm_id3163268"><bookmark_value>ROUNDUP function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_AUFRUNDEN" id="bm_id3163280" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AUFRUNDEN" id="bm_id3163280" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3163268" role="heading" level="2" l10n="U" oldref="140">ROUNDUP</paragraph> <paragraph xml-lang="en-US" id="par_id3163297" role="paragraph" l10n="CHG" oldref="141"><ahelp hid="HID_FUNC_AUFRUNDEN">Rounds a number up, away from zero, to a certain precision.</ahelp></paragraph> @@ -937,7 +937,7 @@ CEILING, FLOOR, EVEN, ODD, MROUND</comment> <section id="Section18"> <bookmark xml-lang="en-US" branch="index" id="bm_id3144877"><bookmark_value>SIN function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SIN" id="bm_id3144889" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SIN" id="bm_id3144889" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3144877" role="heading" level="2" l10n="U" oldref="408">SIN</paragraph> <paragraph xml-lang="en-US" id="par_id3144906" role="paragraph" l10n="CHG" oldref="409"><ahelp hid="HID_FUNC_SIN">Returns the sine of the given angle (in radians).</ahelp></paragraph> @@ -957,7 +957,7 @@ ACOS, ASIN, ATAN, ATAN2, ACOT </comment> <section id="Section17"> <bookmark xml-lang="en-US" branch="index" id="bm_id3163397"><bookmark_value>SINH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SINHYP" id="bm_id3163409" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SINHYP" id="bm_id3163409" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3163397" role="heading" level="2" l10n="U" oldref="418">SINH</paragraph> <paragraph xml-lang="en-US" id="par_id3163426" role="paragraph" l10n="U" oldref="419"><ahelp hid="HID_FUNC_SINHYP">Returns the hyperbolic sine of a number.</ahelp></paragraph> @@ -975,7 +975,7 @@ ACOSH, ASINH, ATANH, ACOTH</comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3163596"><bookmark_value>SUM function</bookmark_value> <bookmark_value>adding;numbers in cell ranges</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMME" id="bm_id3163608" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMME" id="bm_id3163608" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3163596" role="heading" level="2" l10n="U" oldref="428">SUM</paragraph> <paragraph xml-lang="en-US" id="par_id3163625" role="paragraph" l10n="U" oldref="429"><ahelp hid="HID_FUNC_SUMME">Adds all the numbers in a range of cells.</ahelp></paragraph> @@ -1003,7 +1003,7 @@ oldref="433">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3151957"><bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3151957" role="heading" level="2" l10n="U" oldref="436">SUMIF</paragraph> <paragraph xml-lang="en-US" id="par_id3151986" role="paragraph" l10n="U" oldref="437"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph> @@ -1026,7 +1026,7 @@ oldref="443">Example</paragraph> <section id="Section14"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TAN" id="bm_id3152207" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3152195" role="heading" level="2" l10n="U" oldref="446">TAN</paragraph> <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> @@ -1046,7 +1046,7 @@ ACOS, ASIN, ATAN, ATAN2, ACOT</comment> <section id="Section13"> <bookmark xml-lang="en-US" branch="index" id="bm_id3165434"><bookmark_value>TANH function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TANHYP" id="bm_id3165446" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TANHYP" id="bm_id3165446" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3165434" role="heading" level="2" l10n="U" oldref="456">TANH</paragraph> <paragraph xml-lang="en-US" id="par_id3165462" role="paragraph" l10n="U" oldref="457"><ahelp hid="HID_FUNC_TANHYP">Returns the hyperbolic tangent of a number.</ahelp></paragraph> @@ -1066,7 +1066,7 @@ ACOSH, ASINH, ATANH, ACOTH</comment> <bookmark_value>filtered data; sums</bookmark_value> <bookmark_value>SUBTOTAL function</bookmark_value> </bookmark><comment>mw made "sums..." a two level entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TEILERGEBNIS" id="bm_id3165644" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEILERGEBNIS" id="bm_id3165644" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3165633" role="heading" level="2" l10n="U" oldref="466">SUBTOTAL</paragraph> <paragraph xml-lang="en-US" id="par_id3165682" role="paragraph" l10n="U" oldref="467"><ahelp hid="HID_FUNC_TEILERGEBNIS">Calculates subtotals.</ahelp> If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.</paragraph> @@ -1185,8 +1185,8 @@ oldref="499">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3143672"><bookmark_value>Euro; converting</bookmark_value> <bookmark_value>EUROCONVERT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_UMRECHNEN" id="bm_id3143684" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_EUROCONVERT" id="bm_id0119200904282677" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UMRECHNEN" id="bm_id3143684" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_EUROCONVERT" id="bm_id0119200904282677" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3143672" role="heading" level="2" l10n="CHG" oldref="564">EUROCONVERT<comment>insert link in financial</comment></paragraph> <paragraph xml-lang="en-US" id="par_id3143708" role="paragraph" l10n="CHG" oldref="565"><ahelp hid="HID_FUNC_UMRECHNEN">Converts between old European national currency and to and from Euros.</ahelp></paragraph> @@ -1209,7 +1209,7 @@ oldref="570"><emph>Examples</emph> <section id="convert"> <bookmark xml-lang="en-US" branch="index" id="bm_id0908200902090676"><bookmark_value>CONVERT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_UMRECHNEN" id="bm_id0908200902093111" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UMRECHNEN" id="bm_id0908200902093111" localize="false"/> <paragraph xml-lang="en-US" id="hd_id0908200902074836" role="heading" level="2" l10n="NEW">CONVERT</paragraph> <paragraph xml-lang="en-US" id="par_id0908200902131122" role="paragraph" l10n="NEW"><ahelp hid=".">Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.</ahelp></paragraph> <paragraph xml-lang="en-US" id="par_id0908200902475420" role="paragraph" l10n="NEW">At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies.</paragraph> @@ -1224,7 +1224,7 @@ oldref="570"><emph>Examples</emph> <bookmark xml-lang="en-US" branch="index" id="bm_id3157177"><bookmark_value>ODD function</bookmark_value> <bookmark_value>rounding;up/down to nearest odd integer</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_UNGERADE" id="bm_id3157188" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNGERADE" id="bm_id3157188" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3157177" role="heading" level="2" l10n="U" oldref="502">ODD</paragraph> <paragraph xml-lang="en-US" id="par_id3157205" role="paragraph" l10n="CHG" oldref="503"><ahelp hid="HID_FUNC_UNGERADE">Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.</ahelp></paragraph> @@ -1248,7 +1248,7 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3157404"><bookmark_value>FLOOR function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3157404" role="heading" level="2" l10n="U" oldref="512">FLOOR</paragraph> <paragraph xml-lang="en-US" id="par_id3157432" role="paragraph" l10n="U" oldref="513"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of Significance.</ahelp></paragraph> @@ -1273,7 +1273,7 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP, </comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3164086"><bookmark_value>SIGN function</bookmark_value> <bookmark_value>algebraic signs</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_VORZEICHEN" id="bm_id3164098" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VORZEICHEN" id="bm_id3164098" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164086" role="heading" level="2" l10n="U" oldref="523">SIGN</paragraph> <paragraph xml-lang="en-US" id="par_id3164115" role="paragraph" l10n="CHG" oldref="524"><ahelp hid="HID_FUNC_VORZEICHEN">Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero.</ahelp></paragraph> @@ -1292,7 +1292,7 @@ oldref="528">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3164252"><bookmark_value>MROUND function</bookmark_value> <bookmark_value>nearest multiple</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_MROUND" id="bm_id3164264" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MROUND" id="bm_id3164264" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164252" role="heading" level="2" l10n="E" oldref="658">MROUND</paragraph> <paragraph xml-lang="en-US" id="par_id3164288" role="paragraph" l10n="CHG" oldref="659"><ahelp hid="HID_AAI_FUNC_MROUND">Returns a number rounded to the nearest multiple of another number.</ahelp></paragraph> @@ -1313,7 +1313,7 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3164375"><bookmark_value>SQRT function</bookmark_value> <bookmark_value>square roots;positive numbers</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_WURZEL" id="bm_id3164387" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WURZEL" id="bm_id3164387" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164375" role="heading" level="2" l10n="U" oldref="532">SQRT</paragraph> <paragraph xml-lang="en-US" id="par_id3164404" role="paragraph" l10n="CHG" oldref="533"><ahelp hid="HID_FUNC_WURZEL">Returns the positive square root of a number.</ahelp></paragraph> @@ -1333,7 +1333,7 @@ oldref="537">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3164560"><bookmark_value>SQRTPI function</bookmark_value> <bookmark_value>square roots;products of Pi</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_SQRTPI" id="bm_id3164572" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_SQRTPI" id="bm_id3164572" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164560" role="heading" level="2" l10n="E" oldref="665">SQRTPI</paragraph> <paragraph xml-lang="en-US" id="par_id3164596" role="paragraph" l10n="CHG" oldref="666"><ahelp hid="HID_AAI_FUNC_SQRTPI">Returns the square root of (PI times a number).</ahelp></paragraph> @@ -1351,7 +1351,7 @@ oldref="669">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3164669"><bookmark_value>random numbers; between limits</bookmark_value> <bookmark_value>RANDBETWEEN function</bookmark_value> </bookmark><comment>mw changed "random numbers;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_RANDBETWEEN" id="bm_id3164680" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_RANDBETWEEN" id="bm_id3164680" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164669" role="heading" level="2" l10n="E" oldref="671">RANDBETWEEN</paragraph> <paragraph xml-lang="en-US" id="par_id3164711" role="paragraph" l10n="CHG" oldref="672"><ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Returns an integer random number in a specified range.</ahelp></paragraph> @@ -1371,7 +1371,7 @@ oldref="675">Example</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3164800"><bookmark_value>RAND function</bookmark_value> <bookmark_value>random numbers;between 0 and 1</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZUFALLSZAHL" id="bm_id3164812" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZUFALLSZAHL" id="bm_id3164812" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164800" role="heading" level="2" l10n="U" oldref="542">RAND</paragraph> <paragraph xml-lang="en-US" id="par_id3164829" role="paragraph" l10n="CHG" oldref="543"><ahelp hid="HID_FUNC_ZUFALLSZAHL">Returns a random number between 0 and 1.</ahelp><comment>The value of 0 can be returned, the value of 1 not.</comment><comment>this is really true after issue 53642 will be fixed</comment></paragraph> @@ -1390,7 +1390,7 @@ oldref="545">Syntax</paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3164897"><bookmark_value>COUNTIF function</bookmark_value> <bookmark_value>counting;specified cells</bookmark_value> </bookmark><comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3164897" role="heading" level="2" l10n="U" oldref="547">COUNTIF</paragraph> <paragraph xml-lang="en-US" id="par_id3164926" role="paragraph" l10n="CHG" oldref="548"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph> |