diff options
Diffstat (limited to 'source/text/scalc/01/04060116.xhp')
| -rw-r--r-- | source/text/scalc/01/04060116.xhp | 338 |
1 files changed, 148 insertions, 190 deletions
diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp index 6d78842f42..00312e7d30 100644 --- a/source/text/scalc/01/04060116.xhp +++ b/source/text/scalc/01/04060116.xhp @@ -22,12 +22,12 @@ <meta> <topic id="textscalc0104060116xml" indexer="include"> - <title xml-lang="en-US" id="tit">Add-in Functions, List of Analysis Functions Part Two</title> + <title 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 branch="index" id="bm_id3145074"><bookmark_value>imaginary numbers in analysis functions</bookmark_value> <bookmark_value>complex numbers in analysis functions</bookmark_value> </bookmark> <h1 id="hd_id3154659"><variable id="head_addin_analysis_two"><link href="text/scalc/01/04060116.xhp">Add-in Functions, List of Analysis Functions Part Two</link></variable></h1> @@ -37,392 +37,350 @@ </section> <sort order="asc" descendant="h2"> <section id="imabs"> - <paragraph xml-lang="en-US" id="par_id3145074" role="paragraph" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id3154959"><bookmark_value>IMABS function</bookmark_value> + <paragraph id="par_id3145074" role="paragraph" localize="false"/> +<bookmark branch="index" id="bm_id3154959"><bookmark_value>IMABS function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMABS" id="bm_id3154541" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMABS" id="bm_id3154541" localize="false"/> <h2 id="hd_id3154959">IMABS</h2> - <paragraph xml-lang="en-US" id="par_id3149895" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMABS">The result is the absolute value of a complex number.</ahelp></paragraph> + <paragraph id="par_id3149895" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMABS">The result is the absolute value of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3151302" role="code">IMABS("ComplexNumber")</paragraph> - <paragraph xml-lang="en-US" id="par_id3153974" role="paragraph"><variable id="complex"><emph>ComplexNumber</emph> is a complex number that is entered in the form "x+yi" or "x+yj". + <paragraph id="par_id3151302" role="code">IMABS("ComplexNumber")</paragraph> + <paragraph id="par_id3153974" role="paragraph"><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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3143222" role="paragraph"> + <paragraph id="par_id3143222" role="paragraph"> <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 branch="index" id="bm_id3145357"><bookmark_value>IMAGINARY function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMAGINARY" id="bm_id3154651" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMAGINARY" id="bm_id3154651" localize="false"/> <h2 id="hd_id3145357">IMAGINARY</h2> - <paragraph xml-lang="en-US" id="par_id3146965" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMAGINARY">The result is the imaginary coefficient of a complex number.</ahelp></paragraph> + <paragraph id="par_id3146965" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMAGINARY">The result is the imaginary coefficient of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3155522" role="code">IMAGINARY("ComplexNumber")</paragraph> + <paragraph id="par_id3155522" role="code">IMAGINARY("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3155592" role="paragraph"> + <paragraph id="par_id3155592" role="paragraph"> <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 branch="index" id="bm_id3146106"><bookmark_value>IMPOWER function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMPOWER" id="bm_id3155755" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMPOWER" id="bm_id3155755" localize="false"/> <h2 id="hd_id3146106">IMPOWER</h2> - <paragraph xml-lang="en-US" id="par_id3147245" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMPOWER">The result is the <emph>ComplexNumber</emph> raised to the power of <emph>Number</emph>.</ahelp></paragraph> + <paragraph id="par_id3147245" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMPOWER">The result is the <emph>ComplexNumber</emph> raised to the power of <emph>Number</emph>.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3147501" role="code">IMPOWER("ComplexNumber"; Number)</paragraph> + <paragraph id="par_id3147501" role="code">IMPOWER("ComplexNumber"; Number)</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> - <paragraph xml-lang="en-US" id="par_id3155743" role="paragraph"> + <paragraph id="par_id3155743" role="paragraph"> <emph>Number</emph> is the exponent.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3151393" role="paragraph"> + <paragraph id="par_id3151393" role="paragraph"> <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 branch="index" id="bm_id3148748"><bookmark_value>IMARGUMENT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMARGUMENT" id="bm_id3147297" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMARGUMENT" id="bm_id3147297" localize="false"/> <h2 id="hd_id3148748">IMARGUMENT</h2> - <paragraph xml-lang="en-US" id="par_id3151341" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMARGUMENT">The result is the argument (the phi angle) of a complex number.</ahelp></paragraph> + <paragraph id="par_id3151341" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMARGUMENT">The result is the argument (the phi angle) of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3156402" role="code">IMARGUMENT("ComplexNumber")</paragraph> + <paragraph id="par_id3156402" role="code">IMARGUMENT("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3159125" role="paragraph"> + <paragraph id="par_id3159125" role="paragraph"> <item type="input">=IMARGUMENT("3+4j")</item> returns 0.927295.</paragraph> </section> <section id="imcos"> - <h2 id="hd_id69271214320055"> - <embedvar href="text/scalc/01/func_imcos.xhp#imcos_head"/> - </h2> - <paragraph id="par_id207971541015759" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imcos.xhp#imcos_des"/> - </paragraph> + <h2 id="hd_id69271214320055" localize="false"><embedvar href="text/scalc/01/func_imcos.xhp#imcos_head"/></h2> + <paragraph id="par_id207971541015759" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imcos.xhp#imcos_des"/></paragraph> </section> <section id="imcosh"> - <h2 id="hd_id217971417131058"> - <embedvar href="text/scalc/01/func_imcosh.xhp#imcosh_head"/> - </h2> - <paragraph id="par_id6527438118584" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imcosh.xhp#imcosh_des"/> - </paragraph> + <h2 id="hd_id217971417131058" localize="false"><embedvar href="text/scalc/01/func_imcosh.xhp#imcosh_head"/></h2> + <paragraph id="par_id6527438118584" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imcosh.xhp#imcosh_des"/></paragraph> </section> <section id="imcot"> - <h2 id="hd_id7625634121212"> - <embedvar href="text/scalc/01/func_imcot.xhp#imcot_head"/> - </h2> - <paragraph id="par_id13708154784779" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imcot.xhp#imcot_des"/> - </paragraph> + <h2 id="hd_id7625634121212" localize="false"><embedvar href="text/scalc/01/func_imcot.xhp#imcot_head"/></h2> + <paragraph id="par_id13708154784779" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imcot.xhp#imcot_des"/></paragraph> </section> <section id="imcsc"> - <h2 id="hd_id2907192866882"> - <embedvar href="text/scalc/01/func_imcsc.xhp#imcsc_head"/> - </h2> - <paragraph id="par_id11614766524423" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imcsc.xhp#imcsc_des"/> - </paragraph> + <h2 id="hd_id2907192866882" localize="false"><embedvar href="text/scalc/01/func_imcsc.xhp#imcsc_head"/></h2> + <paragraph id="par_id11614766524423" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imcsc.xhp#imcsc_des"/></paragraph> </section> <section id="imcsch"> - <h2 id="hd_id2111268313694"> - <embedvar href="text/scalc/01/func_imcsch.xhp#imcsch_head"/> - </h2> - <paragraph id="par_id15108118182663" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imcsch.xhp#imcsch_des"/> - </paragraph> + <h2 id="hd_id2111268313694" localize="false"><embedvar href="text/scalc/01/func_imcsch.xhp#imcsch_head"/></h2> + <paragraph id="par_id15108118182663" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imcsch.xhp#imcsch_des"/></paragraph> </section> <section id="imdiv"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150024"><bookmark_value>IMDIV function</bookmark_value> +<bookmark branch="index" id="bm_id3150024"><bookmark_value>IMDIV function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMDIV" id="bm_id3154679" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMDIV" id="bm_id3154679" localize="false"/> <h2 id="hd_id3150024">IMDIV</h2> - <paragraph xml-lang="en-US" id="par_id3145825" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMDIV">The result is the division of two complex numbers.</ahelp></paragraph> + <paragraph id="par_id3145825" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMDIV">The result is the division of two complex numbers.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3146942" role="code">IMDIV("Numerator"; "Denominator")</paragraph> - <paragraph xml-lang="en-US" id="par_id3150741" role="paragraph"> + <paragraph id="par_id3146942" role="code">IMDIV("Numerator"; "Denominator")</paragraph> + <paragraph id="par_id3150741" role="paragraph"> <emph>Numerator</emph>, <emph>Denominator</emph> are complex numbers that are entered in the form "x+yi" or "x+yj".</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3148440" role="paragraph"> + <paragraph id="par_id3148440" role="paragraph"> <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 branch="index" id="bm_id3153039"><bookmark_value>IMEXP function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMEXP" id="bm_id3147468" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMEXP" id="bm_id3147468" localize="false"/> <h2 id="hd_id3153039">IMEXP</h2> - <paragraph xml-lang="en-US" id="par_id3144741" role="paragraph"><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 id="par_id3144741" role="paragraph"><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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3154810" role="code">IMEXP("ComplexNumber")</paragraph> + <paragraph id="par_id3154810" role="code">IMEXP("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3149253" role="paragraph"> + <paragraph id="par_id3149253" role="paragraph"> <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 branch="index" id="bm_id3149955"><bookmark_value>IMCONJUGATE function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCONJUGATE" id="bm_id3152782" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMCONJUGATE" id="bm_id3152782" localize="false"/> <h2 id="hd_id3149955">IMCONJUGATE</h2> - <paragraph xml-lang="en-US" id="par_id3155263" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMCONJUGATE">The result is the conjugated complex complement to a complex number.</ahelp></paragraph> + <paragraph id="par_id3155263" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMCONJUGATE">The result is the conjugated complex complement to a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3153082" role="code">IMCONJUGATE("ComplexNumber")</paragraph> + <paragraph id="par_id3153082" role="code">IMCONJUGATE("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3149688" role="paragraph"> + <paragraph id="par_id3149688" role="paragraph"> <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 branch="index" id="bm_id3150898"><bookmark_value>IMLN function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMLN" id="bm_id3149190" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMLN" id="bm_id3149190" localize="false"/> <h2 id="hd_id3150898">IMLN</h2> - <paragraph xml-lang="en-US" id="par_id3146853" role="paragraph"><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 id="par_id3146853" role="paragraph"><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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3155954" role="code">IMLN("ComplexNumber")</paragraph> + <paragraph id="par_id3155954" role="code">IMLN("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3153736" role="paragraph"> + <paragraph id="par_id3153736" role="paragraph"> <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 branch="index" id="bm_id3155929"><bookmark_value>IMLOG10 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMLOG10" id="bm_id3148765" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMLOG10" id="bm_id3148765" localize="false"/> <h2 id="hd_id3155929">IMLOG10</h2> - <paragraph xml-lang="en-US" id="par_id3149882" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMLOG10">The result is the common logarithm (to the base 10) of a complex number.</ahelp></paragraph> + <paragraph id="par_id3149882" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMLOG10">The result is the common logarithm (to the base 10) of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3150128" role="code">IMLOG10("ComplexNumber")</paragraph> + <paragraph id="par_id3150128" role="code">IMLOG10("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3151021" role="paragraph"> + <paragraph id="par_id3151021" role="paragraph"> <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 branch="index" id="bm_id3155623"><bookmark_value>IMLOG2 function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMLOG2" id="bm_id3157975" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMLOG2" id="bm_id3157975" localize="false"/> <h2 id="hd_id3155623">IMLOG2</h2> - <paragraph xml-lang="en-US" id="par_id3150932" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMLOG2">The result is the binary logarithm of a complex number.</ahelp></paragraph> + <paragraph id="par_id3150932" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMLOG2">The result is the binary logarithm of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3145355" role="code">IMLOG2("ComplexNumber")</paragraph> + <paragraph id="par_id3145355" role="code">IMLOG2("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3149536" role="paragraph"> + <paragraph id="par_id3149536" role="paragraph"> <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 branch="index" id="bm_id3145626"><bookmark_value>IMPRODUCT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMPRODUCT" id="bm_id3150661" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMPRODUCT" id="bm_id3150661" localize="false"/> <h2 id="hd_id3145626">IMPRODUCT</h2> - <paragraph xml-lang="en-US" id="par_id3153545" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMPRODUCT">The result is the product of a set of complex numbers.</ahelp></paragraph> + <paragraph id="par_id3153545" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMPRODUCT">The result is the product of a set of complex numbers.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149027" role="code">IMPRODUCT(<embedvar href="text/scalc/01/ful_func.xhp#complex255_1" markup="keep"/>)</paragraph> + <paragraph id="par_id3149027" role="code">IMPRODUCT(<embedvar href="text/scalc/01/ful_func.xhp#complex255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#complex255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3155815" role="paragraph"> + <paragraph id="par_id3155815" role="paragraph"> <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 branch="index" id="bm_id3147539"><bookmark_value>IMREAL function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMREAL" id="bm_id3148596" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMREAL" id="bm_id3148596" localize="false"/> <h2 id="hd_id3147539">IMREAL</h2> - <paragraph xml-lang="en-US" id="par_id3155372" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMREAL">The result is the real coefficient of a complex number.</ahelp></paragraph> + <paragraph id="par_id3155372" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMREAL">The result is the real coefficient of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3153927" role="code">IMREAL("ComplexNumber")</paragraph> + <paragraph id="par_id3153927" role="code">IMREAL("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3155986" role="paragraph"> + <paragraph id="par_id3155986" role="paragraph"> <item type="input">=IMREAL("1+3j")</item> returns 1.</paragraph> </section> <section id="imcsec"> - <h2 id="hd_id882954222038"> - <embedvar href="text/scalc/01/func_imsec.xhp#imsec_head"/> - </h2> - <paragraph id="par_id25971292332203" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imsec.xhp#imsec_des"/> - </paragraph> + <h2 id="hd_id882954222038" localize="false"><embedvar href="text/scalc/01/func_imsec.xhp#imsec_head"/></h2> + <paragraph id="par_id25971292332203" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imsec.xhp#imsec_des"/></paragraph> </section> <section id="imcsech"> - <h2 id="hd_id25480538323169"> - <embedvar href="text/scalc/01/func_imsech.xhp#imsech_head"/> - </h2> - <paragraph id="par_id295081583312989" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imsech.xhp#imsech_des"/> - </paragraph> + <h2 id="hd_id25480538323169" localize="false"><embedvar href="text/scalc/01/func_imsech.xhp#imsech_head"/></h2> + <paragraph id="par_id295081583312989" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imsech.xhp#imsech_des"/></paragraph> </section> <section id="imsin"> - <h2 id="hd_id14741462320337"> - <embedvar href="text/scalc/01/func_imsin.xhp#imsin_head"/> - </h2> - <paragraph id="par_id1856698528833" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imsin.xhp#imsin_des"/> - </paragraph> + <h2 id="hd_id14741462320337" localize="false"><embedvar href="text/scalc/01/func_imsin.xhp#imsin_head"/></h2> + <paragraph id="par_id1856698528833" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imsin.xhp#imsin_des"/></paragraph> </section> <section id="imsinh"> - <h2 id="hd_id12978120123414"> - <embedvar href="text/scalc/01/func_imsinh.xhp#imsinh_head"/> - </h2> - <paragraph id="par_id21086201967951" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imsinh.xhp#imsinh_des"/> - </paragraph> + <h2 id="hd_id12978120123414" localize="false"><embedvar href="text/scalc/01/func_imsinh.xhp#imsinh_head"/></h2> + <paragraph id="par_id21086201967951" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imsinh.xhp#imsinh_des"/></paragraph> </section> <section id="imtan"> - <h2 id="hd_id186491693515289"> - <embedvar href="text/scalc/01/func_imtan.xhp#imtan_head"/> - </h2> - <paragraph id="par_id184313129618659" role="paragraph" localize="false" xml-lang="en-US"> - <embedvar href="text/scalc/01/func_imtan.xhp#imtan_des"/> - </paragraph> + <h2 id="hd_id186491693515289" localize="false"><embedvar href="text/scalc/01/func_imtan.xhp#imtan_head"/></h2> + <paragraph id="par_id184313129618659" role="paragraph" localize="false"><embedvar href="text/scalc/01/func_imtan.xhp#imtan_des"/></paragraph> </section> <section id="imsub"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3163826"><bookmark_value>IMSUB function</bookmark_value> +<bookmark branch="index" id="bm_id3163826"><bookmark_value>IMSUB function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSUB" id="bm_id3152481" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMSUB" id="bm_id3152481" localize="false"/> <h2 id="hd_id3163826">IMSUB</h2> - <paragraph xml-lang="en-US" id="par_id3149277" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMSUB">The result is the subtraction of two complex numbers.</ahelp></paragraph> + <paragraph id="par_id3149277" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMSUB">The result is the subtraction of two complex numbers.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3149710" role="code">IMSUB("ComplexNumber1"; "ComplexNumber2")</paragraph> + <paragraph id="par_id3149710" role="code">IMSUB("ComplexNumber1"; "ComplexNumber2")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3150963" role="paragraph"> + <paragraph id="par_id3150963" role="paragraph"> <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 branch="index" id="bm_id3156312"><bookmark_value>IMSUM function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSUM" id="bm_id3149454" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMSUM" id="bm_id3149454" localize="false"/> <h2 id="hd_id3156312">IMSUM</h2> - <paragraph xml-lang="en-US" id="par_id3153215" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMSUM">The result is the sum of a set of complex numbers.</ahelp></paragraph> + <paragraph id="par_id3153215" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMSUM">The result is the sum of a set of complex numbers.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3152930" role="code">IMSUM(<embedvar href="text/scalc/01/ful_func.xhp#complex255_1" markup="keep"/>)</paragraph> + <paragraph id="par_id3152930" role="code">IMSUM(<embedvar href="text/scalc/01/ful_func.xhp#complex255_1" markup="keep"/>)</paragraph> <embed href="text/scalc/01/ful_func.xhp#complex255"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3147081" role="paragraph"> + <paragraph id="par_id3147081" role="paragraph"> <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 branch="index" id="bm_id3147570"><bookmark_value>IMSQRT function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSQRT" id="bm_id3151189" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_IMSQRT" id="bm_id3151189" localize="false"/> <h2 id="hd_id3147570">IMSQRT</h2> - <paragraph xml-lang="en-US" id="par_id3156131" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMSQRT">The result is the square root of a complex number.</ahelp></paragraph> + <paragraph id="par_id3156131" role="paragraph"><ahelp hid="HID_AAI_FUNC_IMSQRT">The result is the square root of a complex number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3150760" role="code">IMSQRT("ComplexNumber")</paragraph> + <paragraph id="par_id3150760" role="code">IMSQRT("ComplexNumber")</paragraph> <embed href="text/scalc/01/04060116.xhp#complex"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3152807" role="paragraph"> + <paragraph id="par_id3152807" role="paragraph"> <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 branch="index" id="bm_id3154054"><bookmark_value>COMPLEX function</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COMPLEX" id="bm_id3156116" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_COMPLEX" id="bm_id3156116" localize="false"/> <h2 id="hd_id3154054">COMPLEX</h2> - <paragraph xml-lang="en-US" id="par_id3156111" role="paragraph"><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 id="par_id3156111" role="paragraph"><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> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3155999" role="code">COMPLEX(RealNum; INum [; Suffix])</paragraph> - <paragraph xml-lang="en-US" id="par_id3153626" role="paragraph"> + <paragraph id="par_id3155999" role="code">COMPLEX(RealNum; INum [; Suffix])</paragraph> + <paragraph id="par_id3153626" role="paragraph"> <emph>RealNum</emph> is the real coefficient of the complex number.</paragraph> - <paragraph xml-lang="en-US" id="par_id3149135" role="paragraph"> + <paragraph id="par_id3149135" role="paragraph"> <emph>INum</emph> is the imaginary coefficient of the complex number.</paragraph> - <paragraph xml-lang="en-US" id="par_id3155849" role="paragraph"> + <paragraph id="par_id3155849" role="paragraph"> <emph>Suffix</emph> is a list of options, "i" or "j".</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3143229" role="paragraph"> + <paragraph id="par_id3143229" role="paragraph"> <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 branch="index" id="bm_id3155103"><bookmark_value>OCT2BIN function</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/SC_HID_AAI_FUNC_OCT2BIN" id="bm_id3149290" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_OCT2BIN" id="bm_id3149290" localize="false"/> <h2 id="hd_id3155103">OCT2BIN</h2> - <paragraph xml-lang="en-US" id="par_id3146898" role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2BIN">The result is the string representing the number in binary (base-2) form for the octal number string entered.</ahelp></paragraph> + <paragraph id="par_id3146898" role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2BIN">The result is the string representing the number in binary (base-2) form for the octal number string entered.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3154303" role="code">OCT2BIN(Number [; Places])</paragraph> - <paragraph xml-lang="en-US" id="par_id3156013" role="paragraph"> + <paragraph id="par_id3154303" role="code">OCT2BIN(Number [; Places])</paragraph> + <paragraph id="par_id3156013" role="paragraph"> <emph>Number</emph> is a string that represents an octal number. It 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"> + <paragraph id="par_id3153984" role="paragraph"> <emph>Places</emph> is the number of places to be output.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3147260" role="paragraph"> + <paragraph id="par_id3147260" role="paragraph"> <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 branch="index" id="bm_id3152791"><bookmark_value>OCT2DEC function</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/SC_HID_AAI_FUNC_OCT2DEZ" id="bm_id3151168" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_OCT2DEZ" id="bm_id3151168" localize="false"/> <h2 id="hd_id3152791">OCT2DEC</h2> - <paragraph xml-lang="en-US" id="par_id3149199" role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2DEZ">The result is the number for the octal number string entered.</ahelp></paragraph> + <paragraph id="par_id3149199" role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2DEZ">The result is the number for the octal number string entered.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3153902" role="code">OCT2DEC(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id3155326" role="paragraph"> + <paragraph id="par_id3153902" role="code">OCT2DEC(Number)</paragraph> + <paragraph id="par_id3155326" role="paragraph"> <emph>Number</emph> is a string that represents an octal number. It 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> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3154930" role="paragraph"> + <paragraph id="par_id3154930" role="paragraph"> <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 branch="index" id="bm_id3155391"><bookmark_value>OCT2HEX function</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/SC_HID_AAI_FUNC_OCT2HEX" id="bm_id3149904" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_OCT2HEX" id="bm_id3149904" localize="false"/> <h2 id="hd_id3155391">OCT2HEX</h2> - <paragraph xml-lang="en-US" id="par_id3148831" role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2HEX">The result is the string representing the number in hexadecimal form for the octal number string entered.</ahelp></paragraph> + <paragraph id="par_id3148831" role="paragraph"><ahelp hid="HID_AAI_FUNC_OCT2HEX">The result is the string representing the number in hexadecimal form for the octal number string entered.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3150523" role="code">OCT2HEX(Number [; Places])</paragraph> - <paragraph xml-lang="en-US" id="par_id3159162" role="paragraph"> + <paragraph id="par_id3150523" role="code">OCT2HEX(Number [; Places])</paragraph> + <paragraph id="par_id3159162" role="paragraph"> <emph>Number</emph> is a string that represents an octal number. It 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"> + <paragraph id="par_id3145420" role="paragraph"> <emph>Places</emph> is the number of places to be output.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id3148802" role="paragraph"> + <paragraph id="par_id3148802" role="paragraph"> <item type="input">=OCT2HEX("144";4)</item> returns "0064".</paragraph> </section> <section id="convert"> - <h2 id="hd_id14741462320147" localize="false"> - <embedvar href="text/scalc/01/func_convert.xhp#convert_head"/> - </h2> - <paragraph id="par_id1856698528077" role="paragraph" localize="false" xml-lang="en-US"> + <h2 id="hd_id14741462320147" localize="false"><embedvar href="text/scalc/01/func_convert.xhp#convert_head"/></h2> + <paragraph id="par_id1856698528077" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_convert.xhp#convert_desc"/> </paragraph> </section> <section id="factdouble"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3147096"><bookmark_value>FACTDOUBLE function</bookmark_value> +<bookmark branch="index" id="bm_id3147096"><bookmark_value>FACTDOUBLE function</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/SC_HID_AAI_FUNC_FACTDOUBLE" id="bm_id3150950" localize="false"/> +<bookmark branch="hid/SC_HID_AAI_FUNC_FACTDOUBLE" id="bm_id3150950" localize="false"/> <h2 id="hd_id3147096">FACTDOUBLE</h2> - <paragraph xml-lang="en-US" id="par_id3151309" role="paragraph"><ahelp hid="HID_AAI_FUNC_FACTDOUBLE">Returns the double factorial of a number.</ahelp></paragraph> + <paragraph id="par_id3151309" role="paragraph"><ahelp hid="HID_AAI_FUNC_FACTDOUBLE">Returns the double factorial of a number.</ahelp></paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph xml-lang="en-US" id="par_id3155121" role="code">FACTDOUBLE(Number)</paragraph> - <paragraph xml-lang="en-US" id="par_id3158440" role="paragraph">Returns <emph>Number</emph> + <paragraph id="par_id3155121" role="code">FACTDOUBLE(Number)</paragraph> + <paragraph id="par_id3158440" role="paragraph">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">For even numbers FACTDOUBLE(n) returns:</paragraph> - <paragraph xml-lang="en-US" id="par_id4181951" role="paragraph">2*4*6*8* ... *n</paragraph> - <paragraph xml-lang="en-US" id="par_id2927335" role="paragraph">For odd numbers FACTDOUBLE(n) returns:</paragraph> - <paragraph xml-lang="en-US" id="par_id2107303" role="paragraph">1*3*5*7* ... *n</paragraph> - <paragraph xml-lang="en-US" id="par_id4071779" role="paragraph">FACTDOUBLE(0) returns 1 by definition.</paragraph> + <paragraph id="par_id2480849" role="paragraph">For even numbers FACTDOUBLE(n) returns:</paragraph> + <paragraph id="par_id4181951" role="paragraph">2*4*6*8* ... *n</paragraph> + <paragraph id="par_id2927335" role="paragraph">For odd numbers FACTDOUBLE(n) returns:</paragraph> + <paragraph id="par_id2107303" role="paragraph">1*3*5*7* ... *n</paragraph> + <paragraph id="par_id4071779" role="paragraph">FACTDOUBLE(0) returns 1 by definition.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph xml-lang="en-US" id="par_id7844477" role="paragraph"> + <paragraph id="par_id7844477" role="paragraph"> <item type="input">=FACTDOUBLE(5)</item> returns 15.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154116" role="paragraph"> + <paragraph id="par_id3154116" role="paragraph"> <item type="input">=FACTDOUBLE(6)</item> returns 48.</paragraph> - <paragraph xml-lang="en-US" id="par_id6478469" role="paragraph"> + <paragraph id="par_id6478469" role="paragraph"> <item type="input">=FACTDOUBLE(0)</item> returns 1.</paragraph><comment>see also FACT, MULTINOMIAL, PRODUCT </comment> </section> </sort> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3147072" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060111.xhp#head_addin"/></paragraph> - <paragraph xml-lang="en-US" id="par_id3148869" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060115.xhp#head_addin_analysis_one"/></paragraph> - <paragraph xml-lang="en-US" id="par_id3151242" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060108.xhp#head_statistic"/></paragraph> - <paragraph id="par_id260920161704025898" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/04060100.xhp#drking"/></paragraph> + <paragraph id="par_id3147072" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060111.xhp#head_addin"/></paragraph> + <paragraph id="par_id3148869" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060115.xhp#head_addin_analysis_one"/></paragraph> + <paragraph id="par_id3151242" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060108.xhp#head_statistic"/></paragraph> + <paragraph id="par_id260920161704025898" role="paragraph" localize="false"><embedvar href="text/scalc/01/04060100.xhp#drking"/></paragraph> </section> </body> </helpdocument> |