diff options
| author | Ivo Hinkelmann <ihi@openoffice.org> | 2009-06-12 18:19:30 +0000 |
|---|---|---|
| committer | Ivo Hinkelmann <ihi@openoffice.org> | 2009-06-12 18:19:30 +0000 |
| commit | 4dd442010398f4d280ebaa1de3d066185da00daf (patch) | |
| tree | 21c432407105663703a62af771d16039cde3ae80 /helpcontent2/source/text/scalc/01/04060116.xhp | |
| parent | 2dd63f45787b45ec66c3f1f15edac59c8b4408c1 (diff) | |
CWS-TOOLING: integrate CWS hcshared21
2009-05-13 09:49:59 +0200 ufi r271841 : CWS-TOOLING: rebase CWS hcshared21 to trunk@271427 (milestone: DEV300:m47)
2009-04-16 11:01:43 +0200 ufi r270873 : again
2009-03-17 10:19:50 +0100 ufi r269575 : before builds
2009-02-13 16:03:59 +0100 ufi r267726 : CWS-TOOLING: rebase CWS hcshared21 to trunk@267171 (milestone: DEV300:m41)
2009-02-10 10:30:11 +0100 ufi r267539 : vor neuem rebase Versuch
2009-02-03 15:55:58 +0100 ufi r267334 : before rebase
2009-01-06 10:38:41 +0100 ufi r265901 : i97718
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060116.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/04060116.xhp | 890 |
1 files changed, 469 insertions, 421 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060116.xhp b/helpcontent2/source/text/scalc/01/04060116.xhp index 680b85d3ce..c416f15632 100755 --- a/helpcontent2/source/text/scalc/01/04060116.xhp +++ b/helpcontent2/source/text/scalc/01/04060116.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 04060116.xhp,v $ - * $Revision: 1.11.4.2 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.10 $ * * This file is part of OpenOffice.org. * @@ -35,499 +35,547 @@ <meta> -<topic id="textscalc0104060116xml" indexer="include"> -<title id="tit" xml-lang="en-US">Add-in Functions, List of Analysis Functions Part Two</title> -<filename>/text/scalc/01/04060116.xhp</filename> -</topic> -</meta> -<body> + <topic id="textscalc0104060116xml" indexer="include"> + <title xml-lang="en-US" id="tit">Add-in Functions, List of Analysis Functions Part Two</title> + <filename>/text/scalc/01/04060116.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3145074"><bookmark_value>imaginary numbers in analysis functions</bookmark_value> -<bookmark_value>complex numbers in analysis functions</bookmark_value> + <bookmark_value>complex numbers in analysis functions</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3154659" xml-lang="en-US" level="1" l10n="U" oldref="1">Add-in Functions, List of Analysis Functions Part Two</paragraph> -<section id="howtoget"> -<embed href="text/scalc/00/00000404.xhp#addinana"/> -</section> -<section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3151242" xml-lang="en-US" l10n="U" oldref="174"><link href="text/scalc/01/04060108.xhp" name="Category Statistics">Category Statistics</link></paragraph> -<paragraph role="paragraph" id="par_id3148869" xml-lang="en-US" l10n="U" oldref="5"><link href="text/scalc/01/04060115.xhp" name="Analysis Functions Part One">Analysis Functions Part One</link></paragraph> -<paragraph role="paragraph" id="par_id3147072" xml-lang="en-US" l10n="U" oldref="240"><link href="text/scalc/01/04060111.xhp" name="Back to the Overview">Back to the Overview</link></paragraph> -</section> +<paragraph xml-lang="en-US" id="hd_id3154659" role="heading" level="1" l10n="U" oldref="1">Add-in Functions, List of Analysis Functions Part Two</paragraph> + <section id="howtoget"> + <embed href="text/scalc/00/00000404.xhp#addinana"/> + </section> + <section id="relatedtopics"> + <paragraph xml-lang="en-US" id="par_id3151242" role="paragraph" l10n="U" oldref="174"><link href="text/scalc/01/04060108.xhp" name="Category Statistics">Category Statistics</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3148869" role="paragraph" l10n="U" oldref="5"><link href="text/scalc/01/04060115.xhp" name="Analysis Functions Part One">Analysis Functions Part One</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3147072" role="paragraph" l10n="U" oldref="240"><link href="text/scalc/01/04060111.xhp" name="Back to the Overview">Back to the Overview</link></paragraph> + </section> <sort> <section id="imabs"> -<paragraph role="paragraph" id="par_id3145074" xml-lang="en-US" l10n="E" oldref="166" localize="false"/> + <paragraph xml-lang="en-US" id="par_id3145074" role="paragraph" l10n="E" oldref="166" + localize="false"/> <bookmark xml-lang="en-US" branch="index" id="bm_id3154959"><bookmark_value>IMABS function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMABS" id="bm_id3154541" localize="false"/> -<paragraph role="heading" id="hd_id3154959" xml-lang="en-US" level="2" oldref="44">IMABS</paragraph> -<paragraph role="paragraph" id="par_id3149895" xml-lang="en-US" l10n="U" oldref="45"><ahelp hid="HID_AAI_FUNC_IMABS">The result is the absolute value of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3155382" xml-lang="en-US" level="3" l10n="U" oldref="46">Syntax</paragraph> -<paragraph role="code" id="par_id3151302" xml-lang="en-US" l10n="U" oldref="47">IMABS("ComplexNumber")</paragraph> -<paragraph role="paragraph" id="par_id3153974" xml-lang="en-US" l10n="CHG" oldref="48"><variable id="complex"><emph>ComplexNumber</emph> is a complex number that is entered in the form "x+yi" or "x+yj". +<paragraph xml-lang="en-US" id="hd_id3154959" role="heading" level="2" oldref="44">IMABS</paragraph> + <paragraph xml-lang="en-US" id="par_id3149895" role="paragraph" l10n="U" oldref="45"><ahelp hid="HID_AAI_FUNC_IMABS">The result is the absolute value of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3155382" role="heading" level="3" l10n="U" + oldref="46">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3151302" role="code" l10n="U" oldref="47">IMABS("ComplexNumber")</paragraph> + <paragraph xml-lang="en-US" id="par_id3153974" role="paragraph" l10n="CHG" oldref="48"><variable id="complex"><emph>ComplexNumber</emph> is a complex number that is entered in the form "x+yi" or "x+yj". </variable><comment>no blanks allowed, see i82522</comment></paragraph> -<paragraph role="heading" id="hd_id3149697" xml-lang="en-US" level="3" l10n="U" oldref="49">Example</paragraph> -<paragraph role="paragraph" id="par_id3143222" xml-lang="en-US" l10n="U" oldref="50"> -<item type="input">=IMABS("5+12j")</item> returns 13.</paragraph> -</section> -<section id="imaginary"> + <paragraph xml-lang="en-US" id="hd_id3149697" role="heading" level="3" l10n="U" + oldref="49">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3143222" role="paragraph" l10n="U" oldref="50"> + <item type="input">=IMABS("5+12j")</item> returns 13.</paragraph> + </section> + <section id="imaginary"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145357"><bookmark_value>IMAGINARY function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMAGINARY" id="bm_id3154651" localize="false"/> -<paragraph role="heading" id="hd_id3145357" xml-lang="en-US" level="2" oldref="51">IMAGINARY</paragraph> -<paragraph role="paragraph" id="par_id3146965" xml-lang="en-US" l10n="U" oldref="52"><ahelp hid="HID_AAI_FUNC_IMAGINARY">The result is the imaginary coefficient of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3153555" xml-lang="en-US" level="3" l10n="U" oldref="53">Syntax</paragraph> -<paragraph role="code" id="par_id3155522" xml-lang="en-US" l10n="U" oldref="54">IMAGINARY("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3151193" xml-lang="en-US" level="3" l10n="U" oldref="56">Example</paragraph> -<paragraph role="paragraph" id="par_id3155592" xml-lang="en-US" l10n="U" oldref="57"> -<item type="input">=IMAGINARY("4+3j")</item> returns 3.</paragraph> -</section> -<section id="impower"> +<paragraph xml-lang="en-US" id="hd_id3145357" role="heading" level="2" oldref="51">IMAGINARY</paragraph> + <paragraph xml-lang="en-US" id="par_id3146965" role="paragraph" l10n="U" oldref="52"><ahelp hid="HID_AAI_FUNC_IMAGINARY">The result is the imaginary coefficient of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3153555" role="heading" level="3" l10n="U" + oldref="53">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155522" role="code" l10n="U" oldref="54">IMAGINARY("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3151193" role="heading" level="3" l10n="U" + oldref="56">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3155592" role="paragraph" l10n="U" oldref="57"> + <item type="input">=IMAGINARY("4+3j")</item> returns 3.</paragraph> + </section> + <section id="impower"> <bookmark xml-lang="en-US" branch="index" id="bm_id3146106"><bookmark_value>IMPOWER function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMPOWER" id="bm_id3155755" localize="false"/> -<paragraph role="heading" id="hd_id3146106" xml-lang="en-US" level="2" oldref="58">IMPOWER</paragraph> -<paragraph role="paragraph" id="par_id3147245" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="HID_AAI_FUNC_IMPOWER">The result is the integer power of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3150954" xml-lang="en-US" level="3" l10n="U" oldref="60">Syntax</paragraph> -<paragraph role="code" id="par_id3147501" xml-lang="en-US" l10n="U" oldref="61">IMPOWER("ComplexNumber"; Number)</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="paragraph" id="par_id3155743" xml-lang="en-US" l10n="U" oldref="63"> -<emph>Number</emph> is the exponent.</paragraph> -<paragraph role="heading" id="hd_id3149048" xml-lang="en-US" level="3" l10n="U" oldref="64">Example</paragraph> -<paragraph role="paragraph" id="par_id3151393" xml-lang="en-US" l10n="U" oldref="65"> -<item type="input">=IMPOWER("2+3i";2)</item> returns -5+12i.</paragraph> -</section> -<section id="imargument"> +<paragraph xml-lang="en-US" id="hd_id3146106" role="heading" level="2" oldref="58">IMPOWER</paragraph> + <paragraph xml-lang="en-US" id="par_id3147245" role="paragraph" l10n="U" oldref="59"><ahelp hid="HID_AAI_FUNC_IMPOWER">The result is the integer power of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3150954" role="heading" level="3" l10n="U" + oldref="60">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3147501" role="code" l10n="U" oldref="61">IMPOWER("ComplexNumber"; Number)</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="par_id3155743" role="paragraph" l10n="U" oldref="63"> + <emph>Number</emph> is the exponent.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3149048" role="heading" level="3" l10n="U" + oldref="64">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3151393" role="paragraph" l10n="U" oldref="65"> + <item type="input">=IMPOWER("2+3i";2)</item> returns -5+12i.</paragraph> + </section> + <section id="imargument"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148748"><bookmark_value>IMARGUMENT function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMARGUMENT" id="bm_id3147297" localize="false"/> -<paragraph role="heading" id="hd_id3148748" xml-lang="en-US" level="2" oldref="66">IMARGUMENT</paragraph> -<paragraph role="paragraph" id="par_id3151341" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_AAI_FUNC_IMARGUMENT">The result is the argument (the phi angle) of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3150533" xml-lang="en-US" level="3" l10n="U" oldref="68">Syntax</paragraph> -<paragraph role="code" id="par_id3156402" xml-lang="en-US" l10n="U" oldref="69">IMARGUMENT("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3153019" xml-lang="en-US" level="3" l10n="U" oldref="71">Example</paragraph> -<paragraph role="paragraph" id="par_id3159125" xml-lang="en-US" l10n="U" oldref="72"> -<item type="input">=IMARGUMENT("3+4j")</item> returns 0.927295.</paragraph> -</section> -<section id="imcos"> +<paragraph xml-lang="en-US" id="hd_id3148748" role="heading" level="2" oldref="66">IMARGUMENT</paragraph> + <paragraph xml-lang="en-US" id="par_id3151341" role="paragraph" l10n="U" oldref="67"><ahelp hid="HID_AAI_FUNC_IMARGUMENT">The result is the argument (the phi angle) of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3150533" role="heading" level="3" l10n="U" + oldref="68">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3156402" role="code" l10n="U" oldref="69">IMARGUMENT("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3153019" role="heading" level="3" l10n="U" + oldref="71">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3159125" role="paragraph" l10n="U" oldref="72"> + <item type="input">=IMARGUMENT("3+4j")</item> returns 0.927295.</paragraph> + </section> + <section id="imcos"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149146"><bookmark_value>IMCOS function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMCOS" id="bm_id3150378" localize="false"/> -<paragraph role="heading" id="hd_id3149146" xml-lang="en-US" level="2" oldref="73">IMCOS</paragraph> -<paragraph role="paragraph" id="par_id3149725" xml-lang="en-US" l10n="U" oldref="74"><ahelp hid="HID_AAI_FUNC_IMCOS">The result is the cosine of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3159116" xml-lang="en-US" level="3" l10n="U" oldref="75">Syntax</paragraph> -<paragraph role="code" id="par_id3147415" xml-lang="en-US" l10n="U" oldref="76">IMCOS("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3152980" xml-lang="en-US" level="3" l10n="U" oldref="78">Example</paragraph> -<paragraph role="paragraph" id="par_id3157901" xml-lang="en-US" l10n="U" oldref="79"> -<item type="input">=IMCOS("3+4j") </item>returns -27.03-3.85i (rounded).</paragraph> -</section> -<section id="imdiv"> +<paragraph xml-lang="en-US" id="hd_id3149146" role="heading" level="2" oldref="73">IMCOS</paragraph> + <paragraph xml-lang="en-US" id="par_id3149725" role="paragraph" l10n="U" oldref="74"><ahelp hid="HID_AAI_FUNC_IMCOS">The result is the cosine of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3159116" role="heading" level="3" l10n="U" + oldref="75">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3147415" role="code" l10n="U" oldref="76">IMCOS("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3152980" role="heading" level="3" l10n="U" + oldref="78">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3157901" role="paragraph" l10n="U" oldref="79"> + <item type="input">=IMCOS("3+4j") </item>returns -27.03-3.85i (rounded).</paragraph> + </section> + <section id="imdiv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150024"><bookmark_value>IMDIV function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMDIV" id="bm_id3154679" localize="false"/> -<paragraph role="heading" id="hd_id3150024" xml-lang="en-US" level="2" oldref="80">IMDIV</paragraph> -<paragraph role="paragraph" id="par_id3145825" xml-lang="en-US" l10n="U" oldref="81"><ahelp hid="HID_AAI_FUNC_IMDIV">The result is the division of two complex numbers.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3150465" xml-lang="en-US" level="3" l10n="U" oldref="82">Syntax</paragraph> -<paragraph role="code" id="par_id3146942" xml-lang="en-US" l10n="U" oldref="83">IMDIV("Numerator"; "Denominator")</paragraph> -<paragraph role="paragraph" id="par_id3150741" xml-lang="en-US" l10n="CHG" oldref="84"> -<emph>Numerator</emph>, <emph>Denominator</emph> are complex numbers that are entered in the form "x+yi" or "x+yj".</paragraph> -<paragraph role="heading" id="hd_id3151229" xml-lang="en-US" level="3" l10n="U" oldref="85">Example</paragraph> -<paragraph role="paragraph" id="par_id3148440" xml-lang="en-US" l10n="U" oldref="86"> -<item type="input">=IMDIV("-238+240i";"10+24i")</item> returns 5+12i.</paragraph> -</section> -<section id="imexp"> +<paragraph xml-lang="en-US" id="hd_id3150024" role="heading" level="2" oldref="80">IMDIV</paragraph> + <paragraph xml-lang="en-US" id="par_id3145825" role="paragraph" l10n="U" oldref="81"><ahelp hid="HID_AAI_FUNC_IMDIV">The result is the division of two complex numbers.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3150465" role="heading" level="3" l10n="U" + oldref="82">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3146942" role="code" l10n="U" oldref="83">IMDIV("Numerator"; "Denominator")</paragraph> + <paragraph xml-lang="en-US" id="par_id3150741" role="paragraph" l10n="CHG" oldref="84"> + <emph>Numerator</emph>, <emph>Denominator</emph> are complex numbers that are entered in the form "x+yi" or "x+yj".</paragraph> + <paragraph xml-lang="en-US" id="hd_id3151229" role="heading" level="3" l10n="U" + oldref="85">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3148440" role="paragraph" l10n="U" oldref="86"> + <item type="input">=IMDIV("-238+240i";"10+24i")</item> returns 5+12i.</paragraph> + </section> + <section id="imexp"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153039"><bookmark_value>IMEXP function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMEXP" id="bm_id3147468" localize="false"/> -<paragraph role="heading" id="hd_id3153039" xml-lang="en-US" level="2" oldref="87">IMEXP</paragraph> -<paragraph role="paragraph" id="par_id3144741" xml-lang="en-US" l10n="CHG" oldref="88"><ahelp hid="HID_AAI_FUNC_IMEXP">The result is the power of e and the complex number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> -<paragraph role="heading" id="hd_id3145591" xml-lang="en-US" level="3" l10n="U" oldref="89">Syntax</paragraph> -<paragraph role="code" id="par_id3154810" xml-lang="en-US" l10n="U" oldref="90">IMEXP("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3148581" xml-lang="en-US" level="3" l10n="U" oldref="92">Example</paragraph> -<paragraph role="paragraph" id="par_id3149253" xml-lang="en-US" l10n="U" oldref="93"> -<item type="input">=IMEXP("1+j") </item>returns 1.47+2.29j (rounded).</paragraph> -</section> -<section id="imconjugate"> +<paragraph xml-lang="en-US" id="hd_id3153039" role="heading" level="2" oldref="87">IMEXP</paragraph> + <paragraph xml-lang="en-US" id="par_id3144741" role="paragraph" l10n="CHG" oldref="88"><ahelp hid="HID_AAI_FUNC_IMEXP">The result is the power of e and the complex number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3" l10n="U" + oldref="89">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3154810" role="code" l10n="U" oldref="90">IMEXP("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3148581" role="heading" level="3" l10n="U" + oldref="92">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3149253" role="paragraph" l10n="U" oldref="93"> + <item type="input">=IMEXP("1+j") </item>returns 1.47+2.29j (rounded).</paragraph> + </section> + <section id="imconjugate"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149955"><bookmark_value>IMCONJUGATE function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMCONJUGATE" id="bm_id3152782" localize="false"/> -<paragraph role="heading" id="hd_id3149955" xml-lang="en-US" level="2" oldref="94">IMCONJUGATE</paragraph> -<paragraph role="paragraph" id="par_id3155263" xml-lang="en-US" l10n="U" oldref="95"><ahelp hid="HID_AAI_FUNC_IMCONJUGATE">The result is the conjugated complex complement to a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3148750" xml-lang="en-US" level="3" l10n="U" oldref="96">Syntax</paragraph> -<paragraph role="code" id="par_id3153082" xml-lang="en-US" l10n="U" oldref="97">IMCONJUGATE("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3153326" xml-lang="en-US" level="3" l10n="U" oldref="99">Example</paragraph> -<paragraph role="paragraph" id="par_id3149688" xml-lang="en-US" l10n="U" oldref="100"> -<item type="input">=IMCONJUGATE("1+j")</item> returns 1-j.</paragraph> -</section> -<section id="imln"> +<paragraph xml-lang="en-US" id="hd_id3149955" role="heading" level="2" oldref="94">IMCONJUGATE</paragraph> + <paragraph xml-lang="en-US" id="par_id3155263" role="paragraph" l10n="U" oldref="95"><ahelp hid="HID_AAI_FUNC_IMCONJUGATE">The result is the conjugated complex complement to a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3148750" role="heading" level="3" l10n="U" + oldref="96">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153082" role="code" l10n="U" oldref="97">IMCONJUGATE("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3" l10n="U" + oldref="99">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3149688" role="paragraph" l10n="U" oldref="100"> + <item type="input">=IMCONJUGATE("1+j")</item> returns 1-j.</paragraph> + </section> + <section id="imln"> <bookmark xml-lang="en-US" branch="index" id="bm_id3150898"><bookmark_value>IMLN function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMLN" id="bm_id3149190" localize="false"/> -<paragraph role="heading" id="hd_id3150898" xml-lang="en-US" level="2" oldref="101">IMLN</paragraph> -<paragraph role="paragraph" id="par_id3146853" xml-lang="en-US" l10n="CHG" oldref="102"><ahelp hid="HID_AAI_FUNC_IMLN">The result is the natural logarithm (to the base e) of a complex number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> -<paragraph role="heading" id="hd_id3150008" xml-lang="en-US" level="3" l10n="U" oldref="103">Syntax</paragraph> -<paragraph role="code" id="par_id3155954" xml-lang="en-US" l10n="U" oldref="104">IMLN("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3153565" xml-lang="en-US" level="3" l10n="U" oldref="106">Example</paragraph> -<paragraph role="paragraph" id="par_id3153736" xml-lang="en-US" l10n="U" oldref="107"> -<item type="input">=IMLN("1+j")</item> returns 0.35+0.79j (rounded).</paragraph> -</section> -<section id="imlog10"> +<paragraph xml-lang="en-US" id="hd_id3150898" role="heading" level="2" oldref="101">IMLN</paragraph> + <paragraph xml-lang="en-US" id="par_id3146853" role="paragraph" l10n="CHG" oldref="102"><ahelp hid="HID_AAI_FUNC_IMLN">The result is the natural logarithm (to the base e) of a complex number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3150008" role="heading" level="3" l10n="U" + oldref="103">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155954" role="code" l10n="U" oldref="104">IMLN("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3153565" role="heading" level="3" l10n="U" + oldref="106">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3153736" role="paragraph" l10n="U" oldref="107"> + <item type="input">=IMLN("1+j")</item> returns 0.35+0.79j (rounded).</paragraph> + </section> + <section id="imlog10"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155929"><bookmark_value>IMLOG10 function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMLOG10" id="bm_id3148765" localize="false"/> -<paragraph role="heading" id="hd_id3155929" xml-lang="en-US" level="2" oldref="108">IMLOG10</paragraph> -<paragraph role="paragraph" id="par_id3149882" xml-lang="en-US" l10n="CHG" oldref="109"><ahelp hid="HID_AAI_FUNC_IMLOG10">The result is the common logarithm (to the base 10) of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3154327" xml-lang="en-US" level="3" l10n="U" oldref="110">Syntax</paragraph> -<paragraph role="code" id="par_id3150128" xml-lang="en-US" l10n="U" oldref="111">IMLOG10("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3149003" xml-lang="en-US" level="3" l10n="U" oldref="113">Example</paragraph> -<paragraph role="paragraph" id="par_id3151021" xml-lang="en-US" l10n="U" oldref="114"> -<item type="input">=IMLOG10("1+j")</item> returns 0.15+0.34j (rounded).</paragraph> -</section> -<section id="imlog2"> +<paragraph xml-lang="en-US" id="hd_id3155929" role="heading" level="2" oldref="108">IMLOG10</paragraph> + <paragraph xml-lang="en-US" id="par_id3149882" role="paragraph" l10n="CHG" oldref="109"><ahelp hid="HID_AAI_FUNC_IMLOG10">The result is the common logarithm (to the base 10) of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3154327" role="heading" level="3" l10n="U" + oldref="110">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3150128" role="code" l10n="U" oldref="111">IMLOG10("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3149003" role="heading" level="3" l10n="U" + oldref="113">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3151021" role="paragraph" l10n="U" oldref="114"> + <item type="input">=IMLOG10("1+j")</item> returns 0.15+0.34j (rounded).</paragraph> + </section> + <section id="imlog2"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155623"><bookmark_value>IMLOG2 function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMLOG2" id="bm_id3157975" localize="false"/> -<paragraph role="heading" id="hd_id3155623" xml-lang="en-US" level="2" oldref="115">IMLOG2</paragraph> -<paragraph role="paragraph" id="par_id3150932" xml-lang="en-US" l10n="U" oldref="116"><ahelp hid="HID_AAI_FUNC_IMLOG2">The result is the binary logarithm of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3153046" xml-lang="en-US" level="3" l10n="U" oldref="117">Syntax</paragraph> -<paragraph role="code" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="118">IMLOG2("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3148768" xml-lang="en-US" level="3" l10n="U" oldref="120">Example</paragraph> -<paragraph role="paragraph" id="par_id3149536" xml-lang="en-US" l10n="U" oldref="121"> -<item type="input">=IMLOG2("1+j")</item> returns 0.50+1.13j (rounded).</paragraph> -</section> -<section id="improduct"> +<paragraph xml-lang="en-US" id="hd_id3155623" role="heading" level="2" oldref="115">IMLOG2</paragraph> + <paragraph xml-lang="en-US" id="par_id3150932" role="paragraph" l10n="U" oldref="116"><ahelp hid="HID_AAI_FUNC_IMLOG2">The result is the binary logarithm of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3153046" role="heading" level="3" l10n="U" + oldref="117">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3145355" role="code" l10n="U" oldref="118">IMLOG2("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3148768" role="heading" level="3" l10n="U" + oldref="120">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3149536" role="paragraph" l10n="U" oldref="121"> + <item type="input">=IMLOG2("1+j")</item> returns 0.50+1.13j (rounded).</paragraph> + </section> + <section id="improduct"> <bookmark xml-lang="en-US" branch="index" id="bm_id3145626"><bookmark_value>IMPRODUCT function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMPRODUCT" id="bm_id3150661" localize="false"/> -<paragraph role="heading" id="hd_id3145626" xml-lang="en-US" level="2" oldref="122">IMPRODUCT</paragraph> -<paragraph role="paragraph" id="par_id3153545" xml-lang="en-US" l10n="U" oldref="123"><ahelp hid="HID_AAI_FUNC_IMPRODUCT">The result is the product of up to 29 complex numbers.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3149388" xml-lang="en-US" level="3" l10n="U" oldref="124">Syntax</paragraph> -<paragraph role="code" id="par_id3149027" xml-lang="en-US" l10n="U" oldref="125">IMPRODUCT("ComplexNumber"; "ComplexNumber1"; ...)</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3153228" xml-lang="en-US" level="3" l10n="U" oldref="127">Example</paragraph> -<paragraph role="paragraph" id="par_id3155815" xml-lang="en-US" l10n="U" oldref="128"> -<item type="input">=IMPRODUCT("3+4j";"5-3j")</item> returns 27+11j.</paragraph> -</section> -<section id="imreal"> +<paragraph xml-lang="en-US" id="hd_id3145626" role="heading" level="2" oldref="122">IMPRODUCT</paragraph> + <paragraph xml-lang="en-US" id="par_id3153545" role="paragraph" l10n="U" oldref="123"><ahelp hid="HID_AAI_FUNC_IMPRODUCT">The result is the product of up to 29 complex numbers.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3149388" role="heading" level="3" l10n="U" + oldref="124">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3149027" role="code" l10n="U" oldref="125">IMPRODUCT("ComplexNumber"; "ComplexNumber1"; ...)</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U" + oldref="127">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3155815" role="paragraph" l10n="U" oldref="128"> + <item type="input">=IMPRODUCT("3+4j";"5-3j")</item> returns 27+11j.</paragraph> + </section> + <section id="imreal"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147539"><bookmark_value>IMREAL function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMREAL" id="bm_id3148596" localize="false"/> -<paragraph role="heading" id="hd_id3147539" xml-lang="en-US" level="2" oldref="129">IMREAL</paragraph> -<paragraph role="paragraph" id="par_id3155372" xml-lang="en-US" l10n="U" oldref="130"><ahelp hid="HID_AAI_FUNC_IMREAL">The result is the real coefficient of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3154951" xml-lang="en-US" level="3" l10n="U" oldref="131">Syntax</paragraph> -<paragraph role="code" id="par_id3153927" xml-lang="en-US" l10n="U" oldref="132">IMREAL("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3155409" xml-lang="en-US" level="3" l10n="U" oldref="134">Example</paragraph> -<paragraph role="paragraph" id="par_id3155986" xml-lang="en-US" l10n="U" oldref="135"> -<item type="input">=IMREAL("1+3j")</item> returns 1.</paragraph> -</section> -<section id="imsin"> +<paragraph xml-lang="en-US" id="hd_id3147539" role="heading" level="2" oldref="129">IMREAL</paragraph> + <paragraph xml-lang="en-US" id="par_id3155372" role="paragraph" l10n="U" oldref="130"><ahelp hid="HID_AAI_FUNC_IMREAL">The result is the real coefficient of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3154951" role="heading" level="3" l10n="U" + oldref="131">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153927" role="code" l10n="U" oldref="132">IMREAL("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3155409" role="heading" level="3" l10n="U" + oldref="134">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3155986" role="paragraph" l10n="U" oldref="135"> + <item type="input">=IMREAL("1+3j")</item> returns 1.</paragraph> + </section> + <section id="imsin"> <bookmark xml-lang="en-US" branch="index" id="bm_id3148431"><bookmark_value>IMSIN function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSIN" id="bm_id3153716" localize="false"/> -<paragraph role="heading" id="hd_id3148431" xml-lang="en-US" level="2" oldref="136">IMSIN</paragraph> -<paragraph role="paragraph" id="par_id3152591" xml-lang="en-US" l10n="U" oldref="137"><ahelp hid="HID_AAI_FUNC_IMSIN">The result is the sine of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3149822" xml-lang="en-US" level="3" l10n="U" oldref="138">Syntax</paragraph> -<paragraph role="code" id="par_id3150387" xml-lang="en-US" l10n="U" oldref="139">IMSIN("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3150613" xml-lang="en-US" level="3" l10n="U" oldref="141">Example</paragraph> -<paragraph role="paragraph" id="par_id3154310" xml-lang="en-US" l10n="U" oldref="142"> -<item type="input">=IMSIN("3+4j")</item> returns 3.85+27.02j (rounded).</paragraph> -</section> -<section id="imsub"> +<paragraph xml-lang="en-US" id="hd_id3148431" role="heading" level="2" oldref="136">IMSIN</paragraph> + <paragraph xml-lang="en-US" id="par_id3152591" role="paragraph" l10n="U" oldref="137"><ahelp hid="HID_AAI_FUNC_IMSIN">The result is the sine of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3149822" role="heading" level="3" l10n="U" + oldref="138">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3150387" role="code" l10n="U" oldref="139">IMSIN("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3150613" role="heading" level="3" l10n="U" + oldref="141">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3154310" role="paragraph" l10n="U" oldref="142"> + <item type="input">=IMSIN("3+4j")</item> returns 3.85+27.02j (rounded).</paragraph> + </section> + <section id="imsub"> <bookmark xml-lang="en-US" branch="index" id="bm_id3163826"><bookmark_value>IMSUB function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSUB" id="bm_id3152481" localize="false"/> -<paragraph role="heading" id="hd_id3163826" xml-lang="en-US" level="2" oldref="143">IMSUB</paragraph> -<paragraph role="paragraph" id="par_id3149277" xml-lang="en-US" l10n="U" oldref="144"><ahelp hid="HID_AAI_FUNC_IMSUB">The result is the subtraction of two complex numbers.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3149264" xml-lang="en-US" level="3" l10n="U" oldref="145">Syntax</paragraph> -<paragraph role="code" id="par_id3149710" xml-lang="en-US" l10n="U" oldref="146">IMSUB("ComplexNumber1"; "ComplexNumber2")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3155833" xml-lang="en-US" level="3" l10n="U" oldref="148">Example</paragraph> -<paragraph role="paragraph" id="par_id3150963" xml-lang="en-US" l10n="U" oldref="149"> -<item type="input">=IMSUB("13+4j";"5+3j")</item> returns 8+j.</paragraph> -</section> -<section id="imsum"> +<paragraph xml-lang="en-US" id="hd_id3163826" role="heading" level="2" oldref="143">IMSUB</paragraph> + <paragraph xml-lang="en-US" id="par_id3149277" role="paragraph" l10n="U" oldref="144"><ahelp hid="HID_AAI_FUNC_IMSUB">The result is the subtraction of two complex numbers.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3149264" role="heading" level="3" l10n="U" + oldref="145">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3149710" role="code" l10n="U" oldref="146">IMSUB("ComplexNumber1"; "ComplexNumber2")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3155833" role="heading" level="3" l10n="U" + oldref="148">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3150963" role="paragraph" l10n="U" oldref="149"> + <item type="input">=IMSUB("13+4j";"5+3j")</item> returns 8+j.</paragraph> + </section> + <section id="imsum"> <bookmark xml-lang="en-US" branch="index" id="bm_id3156312"><bookmark_value>IMSUM function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSUM" id="bm_id3149454" localize="false"/> -<paragraph role="heading" id="hd_id3156312" xml-lang="en-US" level="2" oldref="150">IMSUM</paragraph> -<paragraph role="paragraph" id="par_id3153215" xml-lang="en-US" l10n="U" oldref="151"><ahelp hid="HID_AAI_FUNC_IMSUM">The result is the sum of up to 29 complex numbers.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3156095" xml-lang="en-US" level="3" l10n="U" oldref="152">Syntax</paragraph> -<paragraph role="code" id="par_id3152930" xml-lang="en-US" l10n="U" oldref="153">IMSUM("ComplexNumber1"; "ComplexNumber2"; ...)</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3154640" xml-lang="en-US" level="3" l10n="U" oldref="155">Example</paragraph> -<paragraph role="paragraph" id="par_id3147081" xml-lang="en-US" l10n="U" oldref="156"> -<item type="input">=IMSUM("13+4j";"5+3j")</item> returns 18+7j.</paragraph> -</section> -<section id="imsqrt"> +<paragraph xml-lang="en-US" id="hd_id3156312" role="heading" level="2" oldref="150">IMSUM</paragraph> + <paragraph xml-lang="en-US" id="par_id3153215" role="paragraph" l10n="U" oldref="151"><ahelp hid="HID_AAI_FUNC_IMSUM">The result is the sum of up to 29 complex numbers.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3156095" role="heading" level="3" l10n="U" + oldref="152">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3152930" role="code" l10n="U" oldref="153">IMSUM("ComplexNumber1"; "ComplexNumber2"; ...)</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3154640" role="heading" level="3" l10n="U" + oldref="155">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3147081" role="paragraph" l10n="U" oldref="156"> + <item type="input">=IMSUM("13+4j";"5+3j")</item> returns 18+7j.</paragraph> + </section> + <section id="imsqrt"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147570"><bookmark_value>IMSQRT function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSQRT" id="bm_id3151189" localize="false"/> -<paragraph role="heading" id="hd_id3147570" xml-lang="en-US" level="2" oldref="167">IMSQRT</paragraph> -<paragraph role="paragraph" id="par_id3156131" xml-lang="en-US" l10n="U" oldref="168"><ahelp hid="HID_AAI_FUNC_IMSQRT">The result is the square root of a complex number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3145202" xml-lang="en-US" level="3" l10n="U" oldref="169">Syntax</paragraph> -<paragraph role="code" id="par_id3150760" xml-lang="en-US" l10n="U" oldref="170">IMSQRT("ComplexNumber")</paragraph> -<embed href="text/scalc/01/04060116.xhp#complex"/> -<paragraph role="heading" id="hd_id3147268" xml-lang="en-US" level="3" l10n="U" oldref="172">Example</paragraph> -<paragraph role="paragraph" id="par_id3152807" xml-lang="en-US" l10n="U" oldref="173"> -<item type="input">=IMSQRT("3+4i")</item> returns 2+1i.</paragraph> -</section> -<section id="complexfunc"> +<paragraph xml-lang="en-US" id="hd_id3147570" role="heading" level="2" oldref="167">IMSQRT</paragraph> + <paragraph xml-lang="en-US" id="par_id3156131" role="paragraph" l10n="U" oldref="168"><ahelp hid="HID_AAI_FUNC_IMSQRT">The result is the square root of a complex number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3145202" role="heading" level="3" l10n="U" + oldref="169">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3150760" role="code" l10n="U" oldref="170">IMSQRT("ComplexNumber")</paragraph> + <embed href="text/scalc/01/04060116.xhp#complex"/> + <paragraph xml-lang="en-US" id="hd_id3147268" role="heading" level="3" l10n="U" + oldref="172">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3152807" role="paragraph" l10n="U" oldref="173"> + <item type="input">=IMSQRT("3+4i")</item> returns 2+1i.</paragraph> + </section> + <section id="complexfunc"> <bookmark xml-lang="en-US" branch="index" id="bm_id3154054"><bookmark_value>COMPLEX function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COMPLEX" id="bm_id3156116" localize="false"/> -<paragraph role="heading" id="hd_id3154054" xml-lang="en-US" level="2" oldref="157">COMPLEX</paragraph> -<paragraph role="paragraph" id="par_id3156111" xml-lang="en-US" l10n="U" oldref="158"><ahelp hid="HID_AAI_FUNC_COMPLEX">The result is a complex number which is returned from a real coefficient and an imaginary coefficient.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3154744" xml-lang="en-US" level="3" l10n="U" oldref="159">Syntax</paragraph> -<paragraph role="code" id="par_id3155999" xml-lang="en-US" l10n="U" oldref="160">COMPLEX(RealNum; INum; Suffix)</paragraph> -<paragraph role="paragraph" id="par_id3153626" xml-lang="en-US" l10n="U" oldref="161"> -<emph>RealNum</emph> is the real coefficient of the complex number.</paragraph> -<paragraph role="paragraph" id="par_id3149135" xml-lang="en-US" l10n="U" oldref="162"> -<emph>INum</emph> is the imaginary coefficient of the complex number.</paragraph> -<paragraph role="paragraph" id="par_id3155849" xml-lang="en-US" l10n="U" oldref="163"> -<emph>Suffix</emph> is a list of options, "i" or "j".</paragraph> -<paragraph role="heading" id="hd_id3145659" xml-lang="en-US" level="3" l10n="U" oldref="164">Example</paragraph> -<paragraph role="paragraph" id="par_id3143229" xml-lang="en-US" l10n="U" oldref="165"> -<item type="input">=COMPLEX(3;4;"j")</item> returns 3+4j.</paragraph> -</section> -<section id="oct2bin"> +<paragraph xml-lang="en-US" id="hd_id3154054" role="heading" level="2" oldref="157">COMPLEX</paragraph> + <paragraph xml-lang="en-US" id="par_id3156111" role="paragraph" l10n="U" oldref="158"><ahelp hid="HID_AAI_FUNC_COMPLEX">The result is a complex number which is returned from a real coefficient and an imaginary coefficient.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3154744" role="heading" level="3" l10n="U" + oldref="159">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155999" role="code" l10n="U" oldref="160">COMPLEX(RealNum; INum; Suffix)</paragraph> + <paragraph xml-lang="en-US" id="par_id3153626" role="paragraph" l10n="U" oldref="161"> + <emph>RealNum</emph> is the real coefficient of the complex number.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149135" role="paragraph" l10n="U" oldref="162"> + <emph>INum</emph> is the imaginary coefficient of the complex number.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155849" role="paragraph" l10n="U" oldref="163"> + <emph>Suffix</emph> is a list of options, "i" or "j".</paragraph> + <paragraph xml-lang="en-US" id="hd_id3145659" role="heading" level="3" l10n="U" + oldref="164">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3143229" role="paragraph" l10n="U" oldref="165"> + <item type="input">=COMPLEX(3;4;"j")</item> returns 3+4j.</paragraph> + </section> + <section id="oct2bin"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155103"><bookmark_value>OCT2BIN function</bookmark_value> -<bookmark_value>converting;octal numbers, into binary numbers</bookmark_value> + <bookmark_value>converting;octal numbers, into binary numbers</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_OCT2BIN" id="bm_id3149290" localize="false"/> -<paragraph role="heading" id="hd_id3155103" xml-lang="en-US" level="2" l10n="E" oldref="217">OCT2BIN</paragraph> -<paragraph role="paragraph" id="par_id3146898" xml-lang="en-US" l10n="U" oldref="218"><ahelp hid="HID_AAI_FUNC_OCT2BIN">The result is the binary number for the octal number entered.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3146088" xml-lang="en-US" level="3" l10n="U" oldref="219">Syntax</paragraph> -<paragraph role="code" id="par_id3154303" xml-lang="en-US" l10n="U" oldref="220">OCT2BIN(Number; Places)</paragraph> -<paragraph role="paragraph" id="par_id3156013" xml-lang="en-US" l10n="U" oldref="221"> -<emph>Number</emph> is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.</paragraph> -<paragraph role="paragraph" id="par_id3153984" xml-lang="en-US" l10n="U" oldref="222"> -<emph>Places</emph> is the number of places to be output.</paragraph> -<paragraph role="heading" id="hd_id3147493" xml-lang="en-US" level="3" l10n="U" oldref="223">Example</paragraph> -<paragraph role="paragraph" id="par_id3147260" xml-lang="en-US" l10n="U" oldref="224"> -<item type="input">=OCT2BIN(3;3)</item> returns 011.</paragraph> -</section> -<section id="oct2dec"> +<paragraph xml-lang="en-US" id="hd_id3155103" role="heading" level="2" l10n="E" + oldref="217">OCT2BIN</paragraph> + <paragraph xml-lang="en-US" id="par_id3146898" role="paragraph" l10n="U" oldref="218"><ahelp hid="HID_AAI_FUNC_OCT2BIN">The result is the binary number for the octal number entered.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3146088" role="heading" level="3" l10n="U" + oldref="219">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3154303" role="code" l10n="U" oldref="220">OCT2BIN(Number; Places)</paragraph> + <paragraph xml-lang="en-US" id="par_id3156013" role="paragraph" l10n="U" oldref="221"> + <emph>Number</emph> is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153984" role="paragraph" l10n="U" oldref="222"> + <emph>Places</emph> is the number of places to be output.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3147493" role="heading" level="3" l10n="U" + oldref="223">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3147260" role="paragraph" l10n="U" oldref="224"> + <item type="input">=OCT2BIN(3;3)</item> returns 011.</paragraph> + </section> + <section id="oct2dec"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152791"><bookmark_value>OCT2DEC function</bookmark_value> -<bookmark_value>converting;octal numbers, into decimal numbers</bookmark_value> + <bookmark_value>converting;octal numbers, into decimal numbers</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_OCT2DEZ" id="bm_id3151168" localize="false"/> -<paragraph role="heading" id="hd_id3152791" xml-lang="en-US" level="2" oldref="225">OCT2DEC</paragraph> -<paragraph role="paragraph" id="par_id3149199" xml-lang="en-US" l10n="U" oldref="226"><ahelp hid="HID_AAI_FUNC_OCT2DEZ">The result is the decimal number for the octal number entered.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3159337" xml-lang="en-US" level="3" l10n="U" oldref="227">Syntax</paragraph> -<paragraph role="code" id="par_id3153902" xml-lang="en-US" l10n="U" oldref="228">OCT2DEC(Number)</paragraph> -<paragraph role="paragraph" id="par_id3155326" xml-lang="en-US" l10n="U" oldref="229"> -<emph>Number</emph> is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.</paragraph> -<paragraph role="heading" id="hd_id3154698" xml-lang="en-US" level="3" l10n="U" oldref="230">Example</paragraph> -<paragraph role="paragraph" id="par_id3154930" xml-lang="en-US" l10n="U" oldref="231"> -<item type="input">=OCT2DEC(144)</item> returns 100.</paragraph> -</section> -<section id="oct2hex"> +<paragraph xml-lang="en-US" id="hd_id3152791" role="heading" level="2" oldref="225">OCT2DEC</paragraph> + <paragraph xml-lang="en-US" id="par_id3149199" role="paragraph" l10n="U" oldref="226"><ahelp hid="HID_AAI_FUNC_OCT2DEZ">The result is the decimal number for the octal number entered.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3159337" role="heading" level="3" l10n="U" + oldref="227">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153902" role="code" l10n="U" oldref="228">OCT2DEC(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id3155326" role="paragraph" l10n="U" oldref="229"> + <emph>Number</emph> is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3154698" role="heading" level="3" l10n="U" + oldref="230">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3154930" role="paragraph" l10n="U" oldref="231"> + <item type="input">=OCT2DEC(144)</item> returns 100.</paragraph> + </section> + <section id="oct2hex"> <bookmark xml-lang="en-US" branch="index" id="bm_id3155391"><bookmark_value>OCT2HEX function</bookmark_value> -<bookmark_value>converting;octal numbers, into hexadecimal numbers</bookmark_value> + <bookmark_value>converting;octal numbers, into hexadecimal numbers</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_OCT2HEX" id="bm_id3149904" localize="false"/> -<paragraph role="heading" id="hd_id3155391" xml-lang="en-US" level="2" oldref="232">OCT2HEX</paragraph> -<paragraph role="paragraph" id="par_id3148831" xml-lang="en-US" l10n="U" oldref="233"><ahelp hid="HID_AAI_FUNC_OCT2HEX"> The result is the hexadecimal number for the octal number entered.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3146988" xml-lang="en-US" level="3" l10n="U" oldref="234">Syntax</paragraph> -<paragraph role="code" id="par_id3150523" xml-lang="en-US" l10n="U" oldref="235">OCT2HEX(Number; Places)</paragraph> -<paragraph role="paragraph" id="par_id3159162" xml-lang="en-US" l10n="U" oldref="236"> -<emph>Number</emph> is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.</paragraph> -<paragraph role="paragraph" id="par_id3145420" xml-lang="en-US" l10n="U" oldref="237"> -<emph>Places</emph> is the number of places to be output.</paragraph> -<paragraph role="heading" id="hd_id3150504" xml-lang="en-US" level="3" l10n="U" oldref="238">Example</paragraph> -<paragraph role="paragraph" id="par_id3148802" xml-lang="en-US" l10n="U" oldref="239"> -<item type="input">=OCT2HEX(144;4)</item> returns 0064.</paragraph> -</section> -<section id="convertadd"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148446"><bookmark_value>CONVERT_ADD function</bookmark_value> +<paragraph xml-lang="en-US" id="hd_id3155391" role="heading" level="2" oldref="232">OCT2HEX</paragraph> + <paragraph xml-lang="en-US" id="par_id3148831" role="paragraph" l10n="U" oldref="233"><ahelp hid="HID_AAI_FUNC_OCT2HEX"> The result is the hexadecimal number for the octal number entered.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3146988" role="heading" level="3" l10n="U" + oldref="234">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3150523" role="code" l10n="U" oldref="235">OCT2HEX(Number; Places)</paragraph> + <paragraph xml-lang="en-US" id="par_id3159162" role="paragraph" l10n="U" oldref="236"> + <emph>Number</emph> is the octal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.</paragraph> + <paragraph xml-lang="en-US" id="par_id3145420" role="paragraph" l10n="U" oldref="237"> + <emph>Places</emph> is the number of places to be output.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3150504" role="heading" level="3" l10n="U" + oldref="238">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id3148802" role="paragraph" l10n="U" oldref="239"> + <item type="input">=OCT2HEX(144;4)</item> returns 0064.</paragraph> + </section> + <section id="convertadd"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3148446"><bookmark_value>CONVERT function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_CONVERT" id="bm_id3150773" localize="false"/> -<paragraph role="heading" id="hd_id3148446" xml-lang="en-US" level="2" oldref="175">CONVERT_ADD</paragraph> -<paragraph role="paragraph" id="par_id3154902" xml-lang="en-US" l10n="U" oldref="176"><ahelp hid="HID_AAI_FUNC_CONVERT">Converts a value from one unit of measure to the corresponding value in another unit of measure.</ahelp> Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l.</paragraph> -<table id="tbl_id3149771"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3153055" xml-lang="en-US" l10n="U" oldref="177">Property</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablehead" id="par_id3147234" xml-lang="en-US" l10n="U" oldref="178">Units</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3147512" xml-lang="en-US" l10n="U" oldref="179">Weight</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3148476" xml-lang="en-US" l10n="U" oldref="180">g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3155361" xml-lang="en-US" l10n="U" oldref="181">Length</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3148925" xml-lang="en-US" l10n="U" oldref="182">m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3158429" xml-lang="en-US" l10n="U" oldref="183">Time</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3150707" xml-lang="en-US" l10n="U" oldref="184">yr, day, hr, mn, sec</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3153238" xml-lang="en-US" l10n="U" oldref="185">Pressure</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3166437" xml-lang="en-US" l10n="U" oldref="186">Pa, atm, mmHg, Torr, psi</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3152944" xml-lang="en-US" l10n="U" oldref="187">Force</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3155582" xml-lang="en-US" l10n="U" oldref="188">N, dyn, pond</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3153686" xml-lang="en-US" l10n="U" oldref="189">Energy</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3153386" xml-lang="en-US" l10n="U" oldref="190">J, e, c, cal, eV, HPh, Wh, BTU</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154100" xml-lang="en-US" l10n="U" oldref="191">Power</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3149915" xml-lang="en-US" l10n="U" oldref="192">W, HP, PS</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3148988" xml-lang="en-US" l10n="U" oldref="193">Field strength</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3148616" xml-lang="en-US" l10n="U" oldref="194">T, ga</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3151120" xml-lang="en-US" l10n="U" oldref="195">Temperature</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3148659" xml-lang="en-US" l10n="U" oldref="196">C, F, K, Reau, Rank</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3154610" xml-lang="en-US" l10n="U" oldref="197">Volume</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3149423" xml-lang="en-US" l10n="U" oldref="198">l, tsp, tbs, oz, cup, pt, qt, gal, m3, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3149244" xml-lang="en-US" l10n="U" oldref="199">Area</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3150425" xml-lang="en-US" l10n="U" oldref="200">m2, mi2, Nmi2, in2, ft2, yd2, ang2, Pica2, Morgen, ar, acre, ha</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3150629" xml-lang="en-US" l10n="U" oldref="201">Speed</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3159246" xml-lang="en-US" l10n="U" oldref="202">m/s, m/h, mph, kn, admkn</paragraph> -</tablecell> -</tablerow> -</table> +<paragraph xml-lang="en-US" id="hd_id3148446" role="heading" level="2" oldref="175">CONVERT<comment>was CONVERT_ADD before. Now CONVERT was changed to EUROCONVERT, and CONVERT_ADD was changed to CONVERT</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3154902" role="paragraph" l10n="U" oldref="176"><ahelp hid="HID_AAI_FUNC_CONVERT">Converts a value from one unit of measure to the corresponding value in another unit of measure.</ahelp> Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l.</paragraph> + <table id="tbl_id3149771"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153055" role="tablehead" l10n="U" oldref="177">Property</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147234" role="tablehead" l10n="U" oldref="178">Units</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3147512" role="tablecontent" l10n="U" oldref="179">Weight</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148476" role="tablecontent" l10n="U" oldref="180">g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155361" role="tablecontent" l10n="U" oldref="181">Length</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148925" role="tablecontent" l10n="U" oldref="182">m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3158429" role="tablecontent" l10n="U" oldref="183">Time</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150707" role="tablecontent" l10n="U" oldref="184">yr, day, hr, mn, sec</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153238" role="tablecontent" l10n="U" oldref="185">Pressure</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3166437" role="tablecontent" l10n="U" oldref="186">Pa, atm, mmHg, Torr, psi</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152944" role="tablecontent" l10n="U" oldref="187">Force</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3155582" role="tablecontent" l10n="U" oldref="188">N, dyn, pond</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153686" role="tablecontent" l10n="U" oldref="189">Energy</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153386" role="tablecontent" l10n="U" oldref="190">J, e, c, cal, eV, HPh, Wh, BTU</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154100" role="tablecontent" l10n="U" oldref="191">Power</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149915" role="tablecontent" l10n="U" oldref="192">W, HP, PS</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148988" role="tablecontent" l10n="U" oldref="193">Field strength</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148616" role="tablecontent" l10n="U" oldref="194">T, ga</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151120" role="tablecontent" l10n="U" oldref="195">Temperature</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148659" role="tablecontent" l10n="U" oldref="196">C, F, K, Reau, Rank</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3154610" role="tablecontent" l10n="U" oldref="197">Volume</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149423" role="tablecontent" l10n="U" oldref="198">l, tsp, tbs, oz, cup, pt, qt, gal, m3, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149244" role="tablecontent" l10n="U" oldref="199">Area</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150425" role="tablecontent" l10n="U" oldref="200">m2, mi2, Nmi2, in2, ft2, yd2, ang2, Pica2, Morgen, ar, acre, ha</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3150629" role="tablecontent" l10n="U" oldref="201">Speed</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3159246" role="tablecontent" l10n="U" oldref="202">m/s, m/h, mph, kn, admkn</paragraph> + </tablecell> + </tablerow> + </table> -<paragraph role="paragraph" id="par_id3143277" xml-lang="en-US" l10n="U" oldref="203">Each unit of measure must be preceded by a prefix character from the following list:</paragraph> -<table id="tbl_id3144759"> -<tablerow> -<tablecell> -<paragraph role="tablehead" id="par_id3148422" xml-lang="en-US" l10n="U" oldref="204">Permitted prefix characters</paragraph> -</tablecell> -<tablecell> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3149490" xml-lang="en-US" l10n="U" oldref="205">10^(<0)</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3149931" xml-lang="en-US" l10n="U" oldref="206">d, c, m, u, n, p, f, a, z, y</paragraph> -</tablecell> -</tablerow> -<tablerow> -<tablecell> -<paragraph role="tablecontent" id="par_id3149589" xml-lang="en-US" l10n="U" oldref="207">10^(>0)</paragraph> -</tablecell> -<tablecell> -<paragraph role="tablecontent" id="par_id3151248" xml-lang="en-US" l10n="U" oldref="208">e, h, k, M, G, T, P, E, Z, Y</paragraph> -</tablecell> -</tablerow> -</table> -<embed href="text/scalc/01/04060102.xhp#ADD_note"/> -<paragraph role="heading" id="hd_id3146125" xml-lang="en-US" level="3" l10n="U" oldref="209">Syntax</paragraph> -<paragraph role="code" id="par_id3153695" xml-lang="en-US" l10n="U" oldref="210">CONVERT_ADD(Number; "FromUnit"; "ToUnit")</paragraph> -<paragraph role="paragraph" id="par_id3147522" xml-lang="en-US" l10n="U" oldref="211"> -<emph>Number</emph> is the number to be converted.</paragraph> -<paragraph role="paragraph" id="par_id3154472" xml-lang="en-US" l10n="U" oldref="212"> -<emph>FromUnit</emph> is the unit from which conversion is taking place.</paragraph> -<paragraph role="paragraph" id="par_id3153790" xml-lang="en-US" l10n="U" oldref="213"> -<emph>ToUnit</emph> is the unit to which conversion is taking place.</paragraph> -<paragraph role="heading" id="hd_id3156270" xml-lang="en-US" level="3" l10n="U" oldref="214">Examples</paragraph> -<paragraph role="paragraph" id="par_id3156336" xml-lang="en-US" l10n="U" oldref="215"> -<item type="input">=CONVERT_ADD(10;"HP";"PS") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS.</paragraph> -<paragraph role="paragraph" id="par_id3154834" xml-lang="en-US" l10n="U" oldref="216"> -<item type="input">=CONVERT_ADD(10;"km";"mi") </item>returns, rounded to two decimal places, 6.21. 10 Kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3.</paragraph> -</section> -<section id="factdouble"> + <paragraph xml-lang="en-US" id="par_id3143277" role="paragraph" l10n="U" oldref="203">Each unit of measure must be preceded by a prefix character from the following list:</paragraph> + <table id="tbl_id3144759"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3148422" role="tablehead" l10n="U" oldref="204">Permitted prefix characters</paragraph> + </tablecell> + <tablecell> +</tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149490" role="tablecontent" l10n="U" oldref="205">10^(<0)</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149931" role="tablecontent" l10n="U" oldref="206">d, c, m, u, n, p, f, a, z, y</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3149589" role="tablecontent" l10n="U" oldref="207">10^(>0)</paragraph> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3151248" role="tablecontent" l10n="U" oldref="208">e, h, k, M, G, T, P, E, Z, Y</paragraph> + </tablecell> + </tablerow> + </table> + <embed href="text/scalc/01/04060102.xhp#ADD_note"/> + <paragraph xml-lang="en-US" id="hd_id3146125" role="heading" level="3" l10n="U" + oldref="209">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3153695" role="code" l10n="U" oldref="210">CONVERT(Number; "FromUnit"; "ToUnit")</paragraph> + <paragraph xml-lang="en-US" id="par_id3147522" role="paragraph" l10n="U" oldref="211"> + <emph>Number</emph> is the number to be converted.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154472" role="paragraph" l10n="U" oldref="212"> + <emph>FromUnit</emph> is the unit from which conversion is taking place.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153790" role="paragraph" l10n="U" oldref="213"> + <emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3156270" role="heading" level="3" l10n="U" + oldref="214">Examples</paragraph> + <paragraph xml-lang="en-US" id="par_id3156336" role="paragraph" l10n="U" oldref="215"> + <item type="input">=CONVERT(10;"HP";"PS") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154834" role="paragraph" l10n="U" oldref="216"> + <item type="input">=CONVERT(10;"km";"mi") </item>returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3.</paragraph> + </section> + <section id="factdouble"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147096"><bookmark_value>FACTDOUBLE function</bookmark_value> -<bookmark_value>factorials;numbers with increments of two</bookmark_value> + <bookmark_value>factorials;numbers with increments of two</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_FACTDOUBLE" id="bm_id3150950" localize="false"/> -<paragraph role="heading" id="hd_id3147096" xml-lang="en-US" level="2" oldref="36">FACTDOUBLE</paragraph> -<paragraph role="paragraph" id="par_id3151309" xml-lang="en-US" l10n="CHG" oldref="37"><ahelp hid="HID_AAI_FUNC_FACTDOUBLE">Returns the double factorial of a number.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3154666" xml-lang="en-US" level="3" l10n="U" oldref="38">Syntax</paragraph> -<paragraph role="code" id="par_id3155121" xml-lang="en-US" l10n="U" oldref="39">FACTDOUBLE(Number)</paragraph> -<paragraph role="paragraph" id="par_id3158440" xml-lang="en-US" l10n="CHG" oldref="40">Returns <emph>Number</emph> -<emph>!!</emph>, the double factorial of <emph>Number</emph>, where <emph>Number</emph> is an integer greater than or equal to zero.</paragraph> -<paragraph role="paragraph" id="par_id2480849" xml-lang="en-US" l10n="NEW">For even numbers FACTDOUBLE(n) returns:</paragraph> -<paragraph role="paragraph" id="par_id4181951" xml-lang="en-US" l10n="NEW">2*4*6*8* ... *n</paragraph> -<paragraph role="paragraph" id="par_id2927335" xml-lang="en-US" l10n="NEW">For odd numbers FACTDOUBLE(n) returns:</paragraph> -<paragraph role="paragraph" id="par_id2107303" xml-lang="en-US" l10n="NEW">1*3*5*7* ... *n</paragraph> -<paragraph role="paragraph" id="par_id4071779" xml-lang="en-US" l10n="NEW">FACTDOUBLE(0) returns 1 by definition.</paragraph> -<paragraph role="heading" id="hd_id3154622" xml-lang="en-US" level="3" l10n="U" oldref="42">Example</paragraph> -<paragraph role="paragraph" id="par_id7844477" xml-lang="en-US" l10n="NEW"> -<item type="input">=FACTDOUBLE(5)</item> returns 15.</paragraph> -<paragraph role="paragraph" id="par_id3154116" xml-lang="en-US" l10n="U" oldref="43"> -<item type="input">=FACTDOUBLE(6)</item> returns 48.</paragraph> -<paragraph role="paragraph" id="par_id6478469" xml-lang="en-US" l10n="NEW"> -<item type="input">=FACTDOUBLE(0)</item> returns 1.</paragraph><comment>see also FACT, MULTINOMIAL, PRODUCT </comment> +<paragraph xml-lang="en-US" id="hd_id3147096" role="heading" level="2" oldref="36">FACTDOUBLE</paragraph> + <paragraph xml-lang="en-US" id="par_id3151309" role="paragraph" l10n="CHG" oldref="37"><ahelp hid="HID_AAI_FUNC_FACTDOUBLE">Returns the double factorial of a number.</ahelp></paragraph> + <paragraph xml-lang="en-US" id="hd_id3154666" role="heading" level="3" l10n="U" + oldref="38">Syntax</paragraph> + <paragraph xml-lang="en-US" id="par_id3155121" role="code" l10n="U" oldref="39">FACTDOUBLE(Number)</paragraph> + <paragraph xml-lang="en-US" id="par_id3158440" role="paragraph" l10n="CHG" oldref="40">Returns <emph>Number</emph> + <emph>!!</emph>, the double factorial of <emph>Number</emph>, where <emph>Number</emph> is an integer greater than or equal to zero.</paragraph> + <paragraph xml-lang="en-US" id="par_id2480849" role="paragraph" l10n="NEW">For even numbers FACTDOUBLE(n) returns:</paragraph> + <paragraph xml-lang="en-US" id="par_id4181951" role="paragraph" l10n="NEW">2*4*6*8* ... *n</paragraph> + <paragraph xml-lang="en-US" id="par_id2927335" role="paragraph" l10n="NEW">For odd numbers FACTDOUBLE(n) returns:</paragraph> + <paragraph xml-lang="en-US" id="par_id2107303" role="paragraph" l10n="NEW">1*3*5*7* ... *n</paragraph> + <paragraph xml-lang="en-US" id="par_id4071779" role="paragraph" l10n="NEW">FACTDOUBLE(0) returns 1 by definition.</paragraph> + <paragraph xml-lang="en-US" id="hd_id3154622" role="heading" level="3" l10n="U" + oldref="42">Example</paragraph> + <paragraph xml-lang="en-US" id="par_id7844477" role="paragraph" l10n="NEW"> + <item type="input">=FACTDOUBLE(5)</item> returns 15.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154116" role="paragraph" l10n="U" oldref="43"> + <item type="input">=FACTDOUBLE(6)</item> returns 48.</paragraph> + <paragraph xml-lang="en-US" id="par_id6478469" role="paragraph" l10n="NEW"> + <item type="input">=FACTDOUBLE(0)</item> returns 1.</paragraph><comment>see also FACT, MULTINOMIAL, PRODUCT </comment> </section> </sort> <section id="Section1"> -<embed href="text/scalc/01/04060100.xhp#drking"/> -</section> -</body> -</helpdocument> + <embed href="text/scalc/01/04060100.xhp#drking"/> + </section> + </body> +</helpdocument>
\ No newline at end of file |