helpcontent2/source/text/scalc/01/04060116.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <helpdocument version="1.0">
   3
   4 <!--
   5 ***********************************************************************
   6  *
   7  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   8  *
   9  * Copyright 2008 by Sun Microsystems, Inc.
  10  *
  11  * OpenOffice.org - a multi-platform office productivity suite
  12  *
  13  * $RCSfile: soffice2xmlhelp.xsl,v $
  14  * $Revision: 1.12 $
  15  *
  16  * This file is part of OpenOffice.org.
  17  *
  18  * OpenOffice.org is free software: you can redistribute it and/or modify
  19  * it under the terms of the GNU Lesser General Public License version 3
  20  * only, as published by the Free Software Foundation.
  21  *
  22  * OpenOffice.org is distributed in the hope that it will be useful,
  23  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  24  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  25  * GNU Lesser General Public License version 3 for more details
  26  * (a copy is included in the LICENSE file that accompanied this code).
  27  *
  28  * You should have received a copy of the GNU Lesser General Public License
  29  * version 3 along with OpenOffice.org.  If not, see
  30  * <http://www.openoffice.org/license.html>
  31  * for a copy of the LGPLv3 License.
  32  *
  33  ************************************************************************
  34  -->
  35
  36
  37 <meta>
  38       <topic id="textscalc0104060116xml" indexer="include">
  39          <title xml-lang="en-US" id="tit">Add-in Functions, List of Analysis Functions Part Two</title>
  40          <filename>/text/scalc/01/04060116.xhp</filename>
  41       </topic>
  42    </meta>
  43    <body>
  44 <bookmark xml-lang="en-US" branch="index" id="bm_id3145074"><bookmark_value>imaginary numbers in analysis functions</bookmark_value>
  45       <bookmark_value>complex numbers in analysis functions</bookmark_value>
  46 </bookmark>
  47 <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>
  48       <section id="howtoget">
  49          <embed href="text/scalc/00/00000404.xhp#addinana"/>
  50       </section>
  51       <section id="relatedtopics">
  52          <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>
  53          <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>
  54          <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>
  55       </section>
  56 <sort>
  57 <section id="imabs">
  58          <paragraph xml-lang="en-US" id="par_id3145074" role="paragraph" l10n="E" oldref="166"
  59                     localize="false"/>
  60 <bookmark xml-lang="en-US" branch="index" id="bm_id3154959"><bookmark_value>IMABS function</bookmark_value>
  61 </bookmark>
  62 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMABS" id="bm_id3154541" localize="false"/>
  63 <paragraph xml-lang="en-US" id="hd_id3154959" role="heading" level="2" oldref="44">IMABS</paragraph>
  64          <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>
  65          <paragraph xml-lang="en-US" id="hd_id3155382" role="heading" level="3" l10n="U"
  66                     oldref="46">Syntax</paragraph>
  67          <paragraph xml-lang="en-US" id="par_id3151302" role="code" l10n="U" oldref="47">IMABS("ComplexNumber")</paragraph>
  68          <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".
  69 </variable><comment>no blanks allowed, see i82522</comment></paragraph>
  70          <paragraph xml-lang="en-US" id="hd_id3149697" role="heading" level="3" l10n="U"
  71                     oldref="49">Example</paragraph>
  72          <paragraph xml-lang="en-US" id="par_id3143222" role="paragraph" l10n="U" oldref="50">
  73             <item type="input">=IMABS("5+12j")</item> returns 13.</paragraph>
  74       </section>
  75       <section id="imaginary">
  76 <bookmark xml-lang="en-US" branch="index" id="bm_id3145357"><bookmark_value>IMAGINARY function</bookmark_value>
  77 </bookmark>
  78 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMAGINARY" id="bm_id3154651" localize="false"/>
  79 <paragraph xml-lang="en-US" id="hd_id3145357" role="heading" level="2" oldref="51">IMAGINARY</paragraph>
  80          <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>
  81          <paragraph xml-lang="en-US" id="hd_id3153555" role="heading" level="3" l10n="U"
  82                     oldref="53">Syntax</paragraph>
  83          <paragraph xml-lang="en-US" id="par_id3155522" role="code" l10n="U" oldref="54">IMAGINARY("ComplexNumber")</paragraph>
  84          <embed href="text/scalc/01/04060116.xhp#complex"/>
  85          <paragraph xml-lang="en-US" id="hd_id3151193" role="heading" level="3" l10n="U"
  86                     oldref="56">Example</paragraph>
  87          <paragraph xml-lang="en-US" id="par_id3155592" role="paragraph" l10n="U" oldref="57">
  88             <item type="input">=IMAGINARY("4+3j")</item> returns 3.</paragraph>
  89       </section>
  90       <section id="impower">
  91 <bookmark xml-lang="en-US" branch="index" id="bm_id3146106"><bookmark_value>IMPOWER function</bookmark_value>
  92 </bookmark>
  93 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMPOWER" id="bm_id3155755" localize="false"/>
  94 <paragraph xml-lang="en-US" id="hd_id3146106" role="heading" level="2" oldref="58">IMPOWER</paragraph>
  95          <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>
  96          <paragraph xml-lang="en-US" id="hd_id3150954" role="heading" level="3" l10n="U"
  97                     oldref="60">Syntax</paragraph>
  98          <paragraph xml-lang="en-US" id="par_id3147501" role="code" l10n="U" oldref="61">IMPOWER("ComplexNumber"; Number)</paragraph>
  99          <embed href="text/scalc/01/04060116.xhp#complex"/>
 100          <paragraph xml-lang="en-US" id="par_id3155743" role="paragraph" l10n="U" oldref="63">
 101             <emph>Number</emph> is the exponent.</paragraph>
 102          <paragraph xml-lang="en-US" id="hd_id3149048" role="heading" level="3" l10n="U"
 103                     oldref="64">Example</paragraph>
 104          <paragraph xml-lang="en-US" id="par_id3151393" role="paragraph" l10n="U" oldref="65">
 105             <item type="input">=IMPOWER("2+3i";2)</item> returns -5+12i.</paragraph>
 106       </section>
 107       <section id="imargument">
 108 <bookmark xml-lang="en-US" branch="index" id="bm_id3148748"><bookmark_value>IMARGUMENT function</bookmark_value>
 109 </bookmark>
 110 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMARGUMENT" id="bm_id3147297" localize="false"/>
 111 <paragraph xml-lang="en-US" id="hd_id3148748" role="heading" level="2" oldref="66">IMARGUMENT</paragraph>
 112          <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>
 113          <paragraph xml-lang="en-US" id="hd_id3150533" role="heading" level="3" l10n="U"
 114                     oldref="68">Syntax</paragraph>
 115          <paragraph xml-lang="en-US" id="par_id3156402" role="code" l10n="U" oldref="69">IMARGUMENT("ComplexNumber")</paragraph>
 116          <embed href="text/scalc/01/04060116.xhp#complex"/>
 117          <paragraph xml-lang="en-US" id="hd_id3153019" role="heading" level="3" l10n="U"
 118                     oldref="71">Example</paragraph>
 119          <paragraph xml-lang="en-US" id="par_id3159125" role="paragraph" l10n="U" oldref="72">
 120             <item type="input">=IMARGUMENT("3+4j")</item> returns 0.927295.</paragraph>
 121       </section>
 122       <section id="imcos">
 123 <bookmark xml-lang="en-US" branch="index" id="bm_id3149146"><bookmark_value>IMCOS function</bookmark_value>
 124 </bookmark>
 125 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMCOS" id="bm_id3150378" localize="false"/>
 126 <paragraph xml-lang="en-US" id="hd_id3149146" role="heading" level="2" oldref="73">IMCOS</paragraph>
 127          <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>
 128          <paragraph xml-lang="en-US" id="hd_id3159116" role="heading" level="3" l10n="U"
 129                     oldref="75">Syntax</paragraph>
 130          <paragraph xml-lang="en-US" id="par_id3147415" role="code" l10n="U" oldref="76">IMCOS("ComplexNumber")</paragraph>
 131          <embed href="text/scalc/01/04060116.xhp#complex"/>
 132          <paragraph xml-lang="en-US" id="hd_id3152980" role="heading" level="3" l10n="U"
 133                     oldref="78">Example</paragraph>
 134          <paragraph xml-lang="en-US" id="par_id3157901" role="paragraph" l10n="U" oldref="79">
 135             <item type="input">=IMCOS("3+4j") </item>returns -27.03-3.85i (rounded).</paragraph>
 136       </section>
 137       <section id="imdiv">
 138 <bookmark xml-lang="en-US" branch="index" id="bm_id3150024"><bookmark_value>IMDIV function</bookmark_value>
 139 </bookmark>
 140 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMDIV" id="bm_id3154679" localize="false"/>
 141 <paragraph xml-lang="en-US" id="hd_id3150024" role="heading" level="2" oldref="80">IMDIV</paragraph>
 142          <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>
 143          <paragraph xml-lang="en-US" id="hd_id3150465" role="heading" level="3" l10n="U"
 144                     oldref="82">Syntax</paragraph>
 145          <paragraph xml-lang="en-US" id="par_id3146942" role="code" l10n="U" oldref="83">IMDIV("Numerator"; "Denominator")</paragraph>
 146          <paragraph xml-lang="en-US" id="par_id3150741" role="paragraph" l10n="CHG" oldref="84">
 147             <emph>Numerator</emph>, <emph>Denominator</emph> are complex numbers that are entered in the form "x+yi" or "x+yj".</paragraph>
 148          <paragraph xml-lang="en-US" id="hd_id3151229" role="heading" level="3" l10n="U"
 149                     oldref="85">Example</paragraph>
 150          <paragraph xml-lang="en-US" id="par_id3148440" role="paragraph" l10n="U" oldref="86">
 151             <item type="input">=IMDIV("-238+240i";"10+24i")</item> returns 5+12i.</paragraph>
 152       </section>
 153       <section id="imexp">
 154 <bookmark xml-lang="en-US" branch="index" id="bm_id3153039"><bookmark_value>IMEXP function</bookmark_value>
 155 </bookmark>
 156 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMEXP" id="bm_id3147468" localize="false"/>
 157 <paragraph xml-lang="en-US" id="hd_id3153039" role="heading" level="2" oldref="87">IMEXP</paragraph>
 158          <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>
 159          <paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3" l10n="U"
 160                     oldref="89">Syntax</paragraph>
 161          <paragraph xml-lang="en-US" id="par_id3154810" role="code" l10n="U" oldref="90">IMEXP("ComplexNumber")</paragraph>
 162          <embed href="text/scalc/01/04060116.xhp#complex"/>
 163          <paragraph xml-lang="en-US" id="hd_id3148581" role="heading" level="3" l10n="U"
 164                     oldref="92">Example</paragraph>
 165          <paragraph xml-lang="en-US" id="par_id3149253" role="paragraph" l10n="U" oldref="93">
 166             <item type="input">=IMEXP("1+j") </item>returns 1.47+2.29j (rounded).</paragraph>
 167       </section>
 168       <section id="imconjugate">
 169 <bookmark xml-lang="en-US" branch="index" id="bm_id3149955"><bookmark_value>IMCONJUGATE function</bookmark_value>
 170 </bookmark>
 171 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMCONJUGATE" id="bm_id3152782" localize="false"/>
 172 <paragraph xml-lang="en-US" id="hd_id3149955" role="heading" level="2" oldref="94">IMCONJUGATE</paragraph>
 173          <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>
 174          <paragraph xml-lang="en-US" id="hd_id3148750" role="heading" level="3" l10n="U"
 175                     oldref="96">Syntax</paragraph>
 176          <paragraph xml-lang="en-US" id="par_id3153082" role="code" l10n="U" oldref="97">IMCONJUGATE("ComplexNumber")</paragraph>
 177          <embed href="text/scalc/01/04060116.xhp#complex"/>
 178          <paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3" l10n="U"
 179                     oldref="99">Example</paragraph>
 180          <paragraph xml-lang="en-US" id="par_id3149688" role="paragraph" l10n="U" oldref="100">
 181             <item type="input">=IMCONJUGATE("1+j")</item> returns 1-j.</paragraph>
 182       </section>
 183       <section id="imln">
 184 <bookmark xml-lang="en-US" branch="index" id="bm_id3150898"><bookmark_value>IMLN function</bookmark_value>
 185 </bookmark>
 186 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMLN" id="bm_id3149190" localize="false"/>
 187 <paragraph xml-lang="en-US" id="hd_id3150898" role="heading" level="2" oldref="101">IMLN</paragraph>
 188          <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>
 189          <paragraph xml-lang="en-US" id="hd_id3150008" role="heading" level="3" l10n="U"
 190                     oldref="103">Syntax</paragraph>
 191          <paragraph xml-lang="en-US" id="par_id3155954" role="code" l10n="U" oldref="104">IMLN("ComplexNumber")</paragraph>
 192          <embed href="text/scalc/01/04060116.xhp#complex"/>
 193          <paragraph xml-lang="en-US" id="hd_id3153565" role="heading" level="3" l10n="U"
 194                     oldref="106">Example</paragraph>
 195          <paragraph xml-lang="en-US" id="par_id3153736" role="paragraph" l10n="U" oldref="107">
 196             <item type="input">=IMLN("1+j")</item> returns 0.35+0.79j (rounded).</paragraph>
 197       </section>
 198       <section id="imlog10">
 199 <bookmark xml-lang="en-US" branch="index" id="bm_id3155929"><bookmark_value>IMLOG10 function</bookmark_value>
 200 </bookmark>
 201 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMLOG10" id="bm_id3148765" localize="false"/>
 202 <paragraph xml-lang="en-US" id="hd_id3155929" role="heading" level="2" oldref="108">IMLOG10</paragraph>
 203          <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>
 204          <paragraph xml-lang="en-US" id="hd_id3154327" role="heading" level="3" l10n="U"
 205                     oldref="110">Syntax</paragraph>
 206          <paragraph xml-lang="en-US" id="par_id3150128" role="code" l10n="U" oldref="111">IMLOG10("ComplexNumber")</paragraph>
 207          <embed href="text/scalc/01/04060116.xhp#complex"/>
 208          <paragraph xml-lang="en-US" id="hd_id3149003" role="heading" level="3" l10n="U"
 209                     oldref="113">Example</paragraph>
 210          <paragraph xml-lang="en-US" id="par_id3151021" role="paragraph" l10n="U" oldref="114">
 211             <item type="input">=IMLOG10("1+j")</item> returns 0.15+0.34j (rounded).</paragraph>
 212       </section>
 213       <section id="imlog2">
 214 <bookmark xml-lang="en-US" branch="index" id="bm_id3155623"><bookmark_value>IMLOG2 function</bookmark_value>
 215 </bookmark>
 216 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMLOG2" id="bm_id3157975" localize="false"/>
 217 <paragraph xml-lang="en-US" id="hd_id3155623" role="heading" level="2" oldref="115">IMLOG2</paragraph>
 218          <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>
 219          <paragraph xml-lang="en-US" id="hd_id3153046" role="heading" level="3" l10n="U"
 220                     oldref="117">Syntax</paragraph>
 221          <paragraph xml-lang="en-US" id="par_id3145355" role="code" l10n="U" oldref="118">IMLOG2("ComplexNumber")</paragraph>
 222          <embed href="text/scalc/01/04060116.xhp#complex"/>
 223          <paragraph xml-lang="en-US" id="hd_id3148768" role="heading" level="3" l10n="U"
 224                     oldref="120">Example</paragraph>
 225          <paragraph xml-lang="en-US" id="par_id3149536" role="paragraph" l10n="U" oldref="121">
 226             <item type="input">=IMLOG2("1+j")</item> returns 0.50+1.13j (rounded).</paragraph>
 227       </section>
 228       <section id="improduct">
 229 <bookmark xml-lang="en-US" branch="index" id="bm_id3145626"><bookmark_value>IMPRODUCT function</bookmark_value>
 230 </bookmark>
 231 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMPRODUCT" id="bm_id3150661" localize="false"/>
 232 <paragraph xml-lang="en-US" id="hd_id3145626" role="heading" level="2" oldref="122">IMPRODUCT</paragraph>
 233          <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>
 234          <paragraph xml-lang="en-US" id="hd_id3149388" role="heading" level="3" l10n="U"
 235                     oldref="124">Syntax</paragraph>
 236          <paragraph xml-lang="en-US" id="par_id3149027" role="code" l10n="U" oldref="125">IMPRODUCT("ComplexNumber"; "ComplexNumber1"; ...)</paragraph>
 237          <embed href="text/scalc/01/04060116.xhp#complex"/>
 238          <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U"
 239                     oldref="127">Example</paragraph>
 240          <paragraph xml-lang="en-US" id="par_id3155815" role="paragraph" l10n="U" oldref="128">
 241             <item type="input">=IMPRODUCT("3+4j";"5-3j")</item> returns 27+11j.</paragraph>
 242       </section>
 243       <section id="imreal">
 244 <bookmark xml-lang="en-US" branch="index" id="bm_id3147539"><bookmark_value>IMREAL function</bookmark_value>
 245 </bookmark>
 246 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMREAL" id="bm_id3148596" localize="false"/>
 247 <paragraph xml-lang="en-US" id="hd_id3147539" role="heading" level="2" oldref="129">IMREAL</paragraph>
 248          <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>
 249          <paragraph xml-lang="en-US" id="hd_id3154951" role="heading" level="3" l10n="U"
 250                     oldref="131">Syntax</paragraph>
 251          <paragraph xml-lang="en-US" id="par_id3153927" role="code" l10n="U" oldref="132">IMREAL("ComplexNumber")</paragraph>
 252          <embed href="text/scalc/01/04060116.xhp#complex"/>
 253          <paragraph xml-lang="en-US" id="hd_id3155409" role="heading" level="3" l10n="U"
 254                     oldref="134">Example</paragraph>
 255          <paragraph xml-lang="en-US" id="par_id3155986" role="paragraph" l10n="U" oldref="135">
 256             <item type="input">=IMREAL("1+3j")</item> returns 1.</paragraph>
 257       </section>
 258       <section id="imsin">
 259 <bookmark xml-lang="en-US" branch="index" id="bm_id3148431"><bookmark_value>IMSIN function</bookmark_value>
 260 </bookmark>
 261 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSIN" id="bm_id3153716" localize="false"/>
 262 <paragraph xml-lang="en-US" id="hd_id3148431" role="heading" level="2" oldref="136">IMSIN</paragraph>
 263          <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>
 264          <paragraph xml-lang="en-US" id="hd_id3149822" role="heading" level="3" l10n="U"
 265                     oldref="138">Syntax</paragraph>
 266          <paragraph xml-lang="en-US" id="par_id3150387" role="code" l10n="U" oldref="139">IMSIN("ComplexNumber")</paragraph>
 267          <embed href="text/scalc/01/04060116.xhp#complex"/>
 268          <paragraph xml-lang="en-US" id="hd_id3150613" role="heading" level="3" l10n="U"
 269                     oldref="141">Example</paragraph>
 270          <paragraph xml-lang="en-US" id="par_id3154310" role="paragraph" l10n="U" oldref="142">
 271             <item type="input">=IMSIN("3+4j")</item> returns 3.85+27.02j (rounded).</paragraph>
 272       </section>
 273       <section id="imsub">
 274 <bookmark xml-lang="en-US" branch="index" id="bm_id3163826"><bookmark_value>IMSUB function</bookmark_value>
 275 </bookmark>
 276 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSUB" id="bm_id3152481" localize="false"/>
 277 <paragraph xml-lang="en-US" id="hd_id3163826" role="heading" level="2" oldref="143">IMSUB</paragraph>
 278          <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>
 279          <paragraph xml-lang="en-US" id="hd_id3149264" role="heading" level="3" l10n="U"
 280                     oldref="145">Syntax</paragraph>
 281          <paragraph xml-lang="en-US" id="par_id3149710" role="code" l10n="U" oldref="146">IMSUB("ComplexNumber1"; "ComplexNumber2")</paragraph>
 282          <embed href="text/scalc/01/04060116.xhp#complex"/>
 283          <paragraph xml-lang="en-US" id="hd_id3155833" role="heading" level="3" l10n="U"
 284                     oldref="148">Example</paragraph>
 285          <paragraph xml-lang="en-US" id="par_id3150963" role="paragraph" l10n="U" oldref="149">
 286             <item type="input">=IMSUB("13+4j";"5+3j")</item> returns 8+j.</paragraph>
 287       </section>
 288       <section id="imsum">
 289 <bookmark xml-lang="en-US" branch="index" id="bm_id3156312"><bookmark_value>IMSUM function</bookmark_value>
 290 </bookmark>
 291 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSUM" id="bm_id3149454" localize="false"/>
 292 <paragraph xml-lang="en-US" id="hd_id3156312" role="heading" level="2" oldref="150">IMSUM</paragraph>
 293          <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>
 294          <paragraph xml-lang="en-US" id="hd_id3156095" role="heading" level="3" l10n="U"
 295                     oldref="152">Syntax</paragraph>
 296          <paragraph xml-lang="en-US" id="par_id3152930" role="code" l10n="U" oldref="153">IMSUM("ComplexNumber1"; "ComplexNumber2"; ...)</paragraph>
 297          <embed href="text/scalc/01/04060116.xhp#complex"/>
 298          <paragraph xml-lang="en-US" id="hd_id3154640" role="heading" level="3" l10n="U"
 299                     oldref="155">Example</paragraph>
 300          <paragraph xml-lang="en-US" id="par_id3147081" role="paragraph" l10n="U" oldref="156">
 301             <item type="input">=IMSUM("13+4j";"5+3j")</item> returns 18+7j.</paragraph>
 302       </section>
 303       <section id="imsqrt">
 304 <bookmark xml-lang="en-US" branch="index" id="bm_id3147570"><bookmark_value>IMSQRT function</bookmark_value>
 305 </bookmark>
 306 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_IMSQRT" id="bm_id3151189" localize="false"/>
 307 <paragraph xml-lang="en-US" id="hd_id3147570" role="heading" level="2" oldref="167">IMSQRT</paragraph>
 308          <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>
 309          <paragraph xml-lang="en-US" id="hd_id3145202" role="heading" level="3" l10n="U"
 310                     oldref="169">Syntax</paragraph>
 311          <paragraph xml-lang="en-US" id="par_id3150760" role="code" l10n="U" oldref="170">IMSQRT("ComplexNumber")</paragraph>
 312          <embed href="text/scalc/01/04060116.xhp#complex"/>
 313          <paragraph xml-lang="en-US" id="hd_id3147268" role="heading" level="3" l10n="U"
 314                     oldref="172">Example</paragraph>
 315          <paragraph xml-lang="en-US" id="par_id3152807" role="paragraph" l10n="U" oldref="173">
 316             <item type="input">=IMSQRT("3+4i")</item> returns 2+1i.</paragraph>
 317       </section>
 318       <section id="complexfunc">
 319 <bookmark xml-lang="en-US" branch="index" id="bm_id3154054"><bookmark_value>COMPLEX function</bookmark_value>
 320 </bookmark>
 321 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_COMPLEX" id="bm_id3156116" localize="false"/>
 322 <paragraph xml-lang="en-US" id="hd_id3154054" role="heading" level="2" oldref="157">COMPLEX</paragraph>
 323          <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>
 324          <paragraph xml-lang="en-US" id="hd_id3154744" role="heading" level="3" l10n="U"
 325                     oldref="159">Syntax</paragraph>
 326          <paragraph xml-lang="en-US" id="par_id3155999" role="code" l10n="U" oldref="160">COMPLEX(RealNum; INum; Suffix)</paragraph>
 327          <paragraph xml-lang="en-US" id="par_id3153626" role="paragraph" l10n="U" oldref="161">
 328             <emph>RealNum</emph> is the real coefficient of the complex number.</paragraph>
 329          <paragraph xml-lang="en-US" id="par_id3149135" role="paragraph" l10n="U" oldref="162">
 330             <emph>INum</emph> is the imaginary coefficient of the complex number.</paragraph>
 331          <paragraph xml-lang="en-US" id="par_id3155849" role="paragraph" l10n="U" oldref="163">
 332             <emph>Suffix</emph> is a list of options, "i" or "j".</paragraph>
 333          <paragraph xml-lang="en-US" id="hd_id3145659" role="heading" level="3" l10n="U"
 334                     oldref="164">Example</paragraph>
 335          <paragraph xml-lang="en-US" id="par_id3143229" role="paragraph" l10n="U" oldref="165">
 336             <item type="input">=COMPLEX(3;4;"j")</item> returns 3+4j.</paragraph>
 337       </section>
 338       <section id="oct2bin">
 339 <bookmark xml-lang="en-US" branch="index" id="bm_id3155103"><bookmark_value>OCT2BIN function</bookmark_value>
 340          <bookmark_value>converting;octal numbers, into binary numbers</bookmark_value>
 341 </bookmark><comment>mw added one entry</comment>
 342 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_OCT2BIN" id="bm_id3149290" localize="false"/>
 343 <paragraph xml-lang="en-US" id="hd_id3155103" role="heading" level="2" l10n="E"
 344                     oldref="217">OCT2BIN</paragraph>
 345          <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>
 346          <paragraph xml-lang="en-US" id="hd_id3146088" role="heading" level="3" l10n="U"
 347                     oldref="219">Syntax</paragraph>
 348          <paragraph xml-lang="en-US" id="par_id3154303" role="code" l10n="U" oldref="220">OCT2BIN(Number; Places)</paragraph>
 349          <paragraph xml-lang="en-US" id="par_id3156013" role="paragraph" l10n="U" oldref="221">
 350             <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>
 351          <paragraph xml-lang="en-US" id="par_id3153984" role="paragraph" l10n="U" oldref="222">
 352             <emph>Places</emph> is the number of places to be output.</paragraph>
 353          <paragraph xml-lang="en-US" id="hd_id3147493" role="heading" level="3" l10n="U"
 354                     oldref="223">Example</paragraph>
 355          <paragraph xml-lang="en-US" id="par_id3147260" role="paragraph" l10n="U" oldref="224">
 356             <item type="input">=OCT2BIN(3;3)</item> returns 011.</paragraph>
 357       </section>
 358       <section id="oct2dec">
 359 <bookmark xml-lang="en-US" branch="index" id="bm_id3152791"><bookmark_value>OCT2DEC function</bookmark_value>
 360          <bookmark_value>converting;octal numbers, into decimal numbers</bookmark_value>
 361 </bookmark><comment>mw added one entry</comment>
 362 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_OCT2DEZ" id="bm_id3151168" localize="false"/>
 363 <paragraph xml-lang="en-US" id="hd_id3152791" role="heading" level="2" oldref="225">OCT2DEC</paragraph>
 364          <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>
 365          <paragraph xml-lang="en-US" id="hd_id3159337" role="heading" level="3" l10n="U"
 366                     oldref="227">Syntax</paragraph>
 367          <paragraph xml-lang="en-US" id="par_id3153902" role="code" l10n="U" oldref="228">OCT2DEC(Number)</paragraph>
 368          <paragraph xml-lang="en-US" id="par_id3155326" role="paragraph" l10n="U" oldref="229">
 369             <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>
 370          <paragraph xml-lang="en-US" id="hd_id3154698" role="heading" level="3" l10n="U"
 371                     oldref="230">Example</paragraph>
 372          <paragraph xml-lang="en-US" id="par_id3154930" role="paragraph" l10n="U" oldref="231">
 373             <item type="input">=OCT2DEC(144)</item> returns 100.</paragraph>
 374       </section>
 375       <section id="oct2hex">
 376 <bookmark xml-lang="en-US" branch="index" id="bm_id3155391"><bookmark_value>OCT2HEX function</bookmark_value>
 377          <bookmark_value>converting;octal numbers, into hexadecimal numbers</bookmark_value>
 378 </bookmark><comment>mw added one entry</comment>
 379 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_OCT2HEX" id="bm_id3149904" localize="false"/>
 380 <paragraph xml-lang="en-US" id="hd_id3155391" role="heading" level="2" oldref="232">OCT2HEX</paragraph>
 381          <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>
 382          <paragraph xml-lang="en-US" id="hd_id3146988" role="heading" level="3" l10n="U"
 383                     oldref="234">Syntax</paragraph>
 384          <paragraph xml-lang="en-US" id="par_id3150523" role="code" l10n="U" oldref="235">OCT2HEX(Number; Places)</paragraph>
 385          <paragraph xml-lang="en-US" id="par_id3159162" role="paragraph" l10n="U" oldref="236">
 386             <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>
 387          <paragraph xml-lang="en-US" id="par_id3145420" role="paragraph" l10n="U" oldref="237">
 388             <emph>Places</emph> is the number of places to be output.</paragraph>
 389          <paragraph xml-lang="en-US" id="hd_id3150504" role="heading" level="3" l10n="U"
 390                     oldref="238">Example</paragraph>
 391          <paragraph xml-lang="en-US" id="par_id3148802" role="paragraph" l10n="U" oldref="239">
 392             <item type="input">=OCT2HEX(144;4)</item> returns 0064.</paragraph>
 393       </section>
 394       <section id="convertadd">
 395 <bookmark xml-lang="en-US" branch="index" id="bm_id3148446"><bookmark_value>CONVERT_ADD function</bookmark_value>
 396 </bookmark>
 397 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_CONVERT" id="bm_id3150773" localize="false"/>
 398 <paragraph xml-lang="en-US" id="hd_id3148446" role="heading" level="2" l10n="CHG"
 399                     oldref="175">CONVERT_ADD</paragraph>
 400          <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>
 401          <table id="tbl_id3149771">
 402             <tablerow>
 403                <tablecell>
 404                   <paragraph xml-lang="en-US" id="par_id3153055" role="tablehead" l10n="U" oldref="177">Property</paragraph>
 405                </tablecell>
 406                <tablecell>
 407                   <paragraph xml-lang="en-US" id="par_id3147234" role="tablehead" l10n="U" oldref="178">Units</paragraph>
 408                </tablecell>
 409             </tablerow>
 410             <tablerow>
 411                <tablecell>
 412                   <paragraph xml-lang="en-US" id="par_id3147512" role="tablecontent" l10n="U" oldref="179">Weight</paragraph>
 413                </tablecell>
 414                <tablecell>
 415                   <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>
 416                </tablecell>
 417             </tablerow>
 418             <tablerow>
 419                <tablecell>
 420                   <paragraph xml-lang="en-US" id="par_id3155361" role="tablecontent" l10n="U" oldref="181">Length</paragraph>
 421                </tablecell>
 422                <tablecell>
 423                   <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>
 424                </tablecell>
 425             </tablerow>
 426             <tablerow>
 427                <tablecell>
 428                   <paragraph xml-lang="en-US" id="par_id3158429" role="tablecontent" l10n="U" oldref="183">Time</paragraph>
 429                </tablecell>
 430                <tablecell>
 431                   <paragraph xml-lang="en-US" id="par_id3150707" role="tablecontent" l10n="U" oldref="184">yr, day, hr, mn, sec</paragraph>
 432                </tablecell>
 433             </tablerow>
 434             <tablerow>
 435                <tablecell>
 436                   <paragraph xml-lang="en-US" id="par_id3153238" role="tablecontent" l10n="U" oldref="185">Pressure</paragraph>
 437                </tablecell>
 438                <tablecell>
 439                   <paragraph xml-lang="en-US" id="par_id3166437" role="tablecontent" l10n="U" oldref="186">Pa, atm, mmHg, Torr, psi</paragraph>
 440                </tablecell>
 441             </tablerow>
 442             <tablerow>
 443                <tablecell>
 444                   <paragraph xml-lang="en-US" id="par_id3152944" role="tablecontent" l10n="U" oldref="187">Force</paragraph>
 445                </tablecell>
 446                <tablecell>
 447                   <paragraph xml-lang="en-US" id="par_id3155582" role="tablecontent" l10n="U" oldref="188">N, dyn, pond</paragraph>
 448                </tablecell>
 449             </tablerow>
 450             <tablerow>
 451                <tablecell>
 452                   <paragraph xml-lang="en-US" id="par_id3153686" role="tablecontent" l10n="U" oldref="189">Energy</paragraph>
 453                </tablecell>
 454                <tablecell>
 455                   <paragraph xml-lang="en-US" id="par_id3153386" role="tablecontent" l10n="U" oldref="190">J, e, c, cal, eV, HPh, Wh, BTU</paragraph>
 456                </tablecell>
 457             </tablerow>
 458             <tablerow>
 459                <tablecell>
 460                   <paragraph xml-lang="en-US" id="par_id3154100" role="tablecontent" l10n="U" oldref="191">Power</paragraph>
 461                </tablecell>
 462                <tablecell>
 463                   <paragraph xml-lang="en-US" id="par_id3149915" role="tablecontent" l10n="U" oldref="192">W, HP, PS</paragraph>
 464                </tablecell>
 465             </tablerow>
 466             <tablerow>
 467                <tablecell>
 468                   <paragraph xml-lang="en-US" id="par_id3148988" role="tablecontent" l10n="U" oldref="193">Field strength</paragraph>
 469                </tablecell>
 470                <tablecell>
 471                   <paragraph xml-lang="en-US" id="par_id3148616" role="tablecontent" l10n="U" oldref="194">T, ga</paragraph>
 472                </tablecell>
 473             </tablerow>
 474             <tablerow>
 475                <tablecell>
 476                   <paragraph xml-lang="en-US" id="par_id3151120" role="tablecontent" l10n="U" oldref="195">Temperature</paragraph>
 477                </tablecell>
 478                <tablecell>
 479                   <paragraph xml-lang="en-US" id="par_id3148659" role="tablecontent" l10n="U" oldref="196">C, F, K, Reau, Rank</paragraph>
 480                </tablecell>
 481             </tablerow>
 482             <tablerow>
 483                <tablecell>
 484                   <paragraph xml-lang="en-US" id="par_id3154610" role="tablecontent" l10n="U" oldref="197">Volume</paragraph>
 485                </tablecell>
 486                <tablecell>
 487                   <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>
 488                </tablecell>
 489             </tablerow>
 490             <tablerow>
 491                <tablecell>
 492                   <paragraph xml-lang="en-US" id="par_id3149244" role="tablecontent" l10n="U" oldref="199">Area</paragraph>
 493                </tablecell>
 494                <tablecell>
 495                   <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>
 496                </tablecell>
 497             </tablerow>
 498             <tablerow>
 499                <tablecell>
 500                   <paragraph xml-lang="en-US" id="par_id3150629" role="tablecontent" l10n="U" oldref="201">Speed</paragraph>
 501                </tablecell>
 502                <tablecell>
 503                   <paragraph xml-lang="en-US" id="par_id3159246" role="tablecontent" l10n="U" oldref="202">m/s, m/h, mph, kn, admkn</paragraph>
 504                </tablecell>
 505             </tablerow>
 506          </table>
 507
 508          <paragraph xml-lang="en-US" id="par_id3143277" role="paragraph" l10n="U" oldref="203">Each unit of measure can be preceded by a prefix character from the following list:</paragraph>
 509          <table id="tbl_id3144759">
 510             <tablerow>
 511                <tablecell>
 512                   <paragraph xml-lang="en-US" id="par_id3148422" role="tablehead" l10n="U" oldref="204">Permitted prefix characters</paragraph>
 513                </tablecell>
 514                <tablecell>
 515 </tablecell>
 516             </tablerow>
 517             <tablerow>
 518                <tablecell>
 519                   <paragraph xml-lang="en-US" id="par_id3149490" role="tablecontent" l10n="U" oldref="205">10^(&lt;0)</paragraph>
 520                </tablecell>
 521                <tablecell>
 522                   <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>
 523                </tablecell>
 524             </tablerow>
 525             <tablerow>
 526                <tablecell>
 527                   <paragraph xml-lang="en-US" id="par_id3149589" role="tablecontent" l10n="U" oldref="207">10^(&gt;0)</paragraph>
 528                </tablecell>
 529                <tablecell>
 530                   <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>
 531                </tablecell>
 532             </tablerow>
 533             <tablerow>
 534                <tablecell>
 535                   <paragraph xml-lang="en-US" id="par_id0908200903061174" role="tablecontent" l10n="NEW">Information units "bit" and "byte" may also be prefixed by one of the following IEC 60027-2 / IEEE 1541 prefixes:</paragraph>
 536                </tablecell>
 537                <tablecell>
 538                   <paragraph xml-lang="en-US" id="par_id0908200903090966" role="code" l10n="NEW">ki kibi 1024</paragraph>
 539                   <paragraph xml-lang="en-US" id="par_id0908200903090958" role="code" l10n="NEW">Mi mebi 1048576</paragraph>
 540                   <paragraph xml-lang="en-US" id="par_id0908200903090936" role="code" l10n="NEW">Gi gibi 1073741824</paragraph>
 541                   <paragraph xml-lang="en-US" id="par_id0908200903090975" role="code" l10n="NEW">Ti tebi 1099511627776</paragraph>
 542                   <paragraph xml-lang="en-US" id="par_id0908200903090930" role="code" l10n="NEW">Pi pebi 1125899906842620</paragraph>
 543                   <paragraph xml-lang="en-US" id="par_id0908200903091070" role="code" l10n="NEW">Ei exbi 1152921504606850000</paragraph>
 544                   <paragraph xml-lang="en-US" id="par_id0908200903091097" role="code" l10n="NEW">Zi zebi 1180591620717410000000</paragraph>
 545                   <paragraph xml-lang="en-US" id="par_id0908200903091010" role="code" l10n="NEW">Yi yobi 1208925819614630000000000</paragraph>
 546                </tablecell>
 547             </tablerow>
 548          </table>
 549          <embed href="text/scalc/01/04060102.xhp#ADD_note"/>
 550          <paragraph xml-lang="en-US" id="hd_id3146125" role="heading" level="3" l10n="U"
 551                     oldref="209">Syntax</paragraph>
 552          <paragraph xml-lang="en-US" id="par_id3153695" role="code" l10n="U" oldref="210">CONVERT_ADD(Number; "FromUnit"; "ToUnit")</paragraph>
 553          <paragraph xml-lang="en-US" id="par_id3147522" role="paragraph" l10n="U" oldref="211">
 554             <emph>Number</emph> is the number to be converted.</paragraph>
 555          <paragraph xml-lang="en-US" id="par_id3154472" role="paragraph" l10n="U" oldref="212">
 556             <emph>FromUnit</emph> is the unit from which conversion is taking place.</paragraph>
 557          <paragraph xml-lang="en-US" id="par_id3153790" role="paragraph" l10n="U" oldref="213">
 558             <emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type.</paragraph>
 559          <paragraph xml-lang="en-US" id="hd_id3156270" role="heading" level="3" l10n="U"
 560                     oldref="214">Examples</paragraph>
 561          <paragraph xml-lang="en-US" id="par_id3156336" role="paragraph" l10n="U" oldref="215">
 562             <item type="input">=CONVERT_ADD(10;"HP";"PS") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS.</paragraph>
 563          <paragraph xml-lang="en-US" id="par_id3154834" role="paragraph" l10n="U" oldref="216">
 564             <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>
 565       </section>
 566       <section id="factdouble">
 567 <bookmark xml-lang="en-US" branch="index" id="bm_id3147096"><bookmark_value>FACTDOUBLE function</bookmark_value>
 568          <bookmark_value>factorials;numbers with increments of two</bookmark_value>
 569 </bookmark><comment>mw added one entry</comment>
 570 <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_FACTDOUBLE" id="bm_id3150950" localize="false"/>
 571 <paragraph xml-lang="en-US" id="hd_id3147096" role="heading" level="2" oldref="36">FACTDOUBLE</paragraph>
 572          <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>
 573          <paragraph xml-lang="en-US" id="hd_id3154666" role="heading" level="3" l10n="U"
 574                     oldref="38">Syntax</paragraph>
 575          <paragraph xml-lang="en-US" id="par_id3155121" role="code" l10n="U" oldref="39">FACTDOUBLE(Number)</paragraph>
 576          <paragraph xml-lang="en-US" id="par_id3158440" role="paragraph" l10n="CHG" oldref="40">Returns <emph>Number</emph>
 577             <emph>!!</emph>, the double factorial of <emph>Number</emph>, where <emph>Number</emph> is an integer greater than or equal to zero.</paragraph>
 578          <paragraph xml-lang="en-US" id="par_id2480849" role="paragraph" l10n="NEW">For even numbers FACTDOUBLE(n) returns:</paragraph>
 579          <paragraph xml-lang="en-US" id="par_id4181951" role="paragraph" l10n="NEW">2*4*6*8* ... *n</paragraph>
 580          <paragraph xml-lang="en-US" id="par_id2927335" role="paragraph" l10n="NEW">For odd numbers FACTDOUBLE(n) returns:</paragraph>
 581          <paragraph xml-lang="en-US" id="par_id2107303" role="paragraph" l10n="NEW">1*3*5*7* ... *n</paragraph>
 582          <paragraph xml-lang="en-US" id="par_id4071779" role="paragraph" l10n="NEW">FACTDOUBLE(0) returns 1 by definition.</paragraph>
 583          <paragraph xml-lang="en-US" id="hd_id3154622" role="heading" level="3" l10n="U"
 584                     oldref="42">Example</paragraph>
 585          <paragraph xml-lang="en-US" id="par_id7844477" role="paragraph" l10n="NEW">
 586             <item type="input">=FACTDOUBLE(5)</item> returns 15.</paragraph>
 587          <paragraph xml-lang="en-US" id="par_id3154116" role="paragraph" l10n="U" oldref="43">
 588             <item type="input">=FACTDOUBLE(6)</item> returns 48.</paragraph>
 589          <paragraph xml-lang="en-US" id="par_id6478469" role="paragraph" l10n="NEW">
 590             <item type="input">=FACTDOUBLE(0)</item> returns 1.</paragraph><comment>see also FACT, MULTINOMIAL, PRODUCT  </comment>
 591 </section>
 592 </sort>
 593 <section id="Section1">
 594          <embed href="text/scalc/01/04060100.xhp#drking"/>
 595       </section>
 596    </body>
 597 </helpdocument>