1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at 13 * 14 * http://www.apache.org/licenses/LICENSE-2.0 15 * 16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License. 22 * 23 ***********************************************************--> 24 25 26 27 28<meta> 29 <topic id="textscalc0104060116xml" indexer="include"> 30 <title xml-lang="en-US" id="tit">Add-in Functions, List of Analysis Functions Part Two</title> 31 <filename>/text/scalc/01/04060116.xhp</filename> 32 </topic> 33 </meta> 34 <body> 35<bookmark xml-lang="en-US" branch="index" id="bm_id3145074"><bookmark_value>imaginary numbers in analysis functions</bookmark_value> 36 <bookmark_value>complex numbers in analysis functions</bookmark_value> 37</bookmark> 38<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> 39 <section id="howtoget"> 40 <embed href="text/scalc/00/00000404.xhp#addinana"/> 41 </section> 42 <section id="relatedtopics"> 43 <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> 44 <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> 45 <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> 46 </section> 47<sort> 48<section id="imabs"> 49<bookmark xml-lang="en-US" branch="index" id="bm_id3154959"><bookmark_value>IMABS function</bookmark_value> 50</bookmark> 51<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMABS" id="bm_id3154541" localize="false"/> 52<paragraph xml-lang="en-US" id="hd_id3154959" role="heading" level="2" oldref="44">IMABS</paragraph> 53 <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> 54 <paragraph xml-lang="en-US" id="hd_id3155382" role="heading" level="3" l10n="U" 55 oldref="46">Syntax</paragraph> 56 <paragraph xml-lang="en-US" id="par_id3151302" role="code" l10n="U" oldref="47">IMABS("ComplexNumber")</paragraph> 57 <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". 58</variable><comment>no blanks allowed, see i82522</comment></paragraph> 59 <paragraph xml-lang="en-US" id="hd_id3149697" role="heading" level="3" l10n="U" 60 oldref="49">Example</paragraph> 61 <paragraph xml-lang="en-US" id="par_id3143222" role="paragraph" l10n="U" oldref="50"> 62 <item type="input">=IMABS("5+12j")</item> returns 13.</paragraph> 63 </section> 64 <section id="imaginary"> 65<bookmark xml-lang="en-US" branch="index" id="bm_id3145357"><bookmark_value>IMAGINARY function</bookmark_value> 66</bookmark> 67<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMAGINARY" id="bm_id3154651" localize="false"/> 68<paragraph xml-lang="en-US" id="hd_id3145357" role="heading" level="2" oldref="51">IMAGINARY</paragraph> 69 <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> 70 <paragraph xml-lang="en-US" id="hd_id3153555" role="heading" level="3" l10n="U" 71 oldref="53">Syntax</paragraph> 72 <paragraph xml-lang="en-US" id="par_id3155522" role="code" l10n="U" oldref="54">IMAGINARY("ComplexNumber")</paragraph> 73 <embed href="text/scalc/01/04060116.xhp#complex"/> 74 <paragraph xml-lang="en-US" id="hd_id3151193" role="heading" level="3" l10n="U" 75 oldref="56">Example</paragraph> 76 <paragraph xml-lang="en-US" id="par_id3155592" role="paragraph" l10n="U" oldref="57"> 77 <item type="input">=IMAGINARY("4+3j")</item> returns 3.</paragraph> 78 </section> 79 <section id="impower"> 80<bookmark xml-lang="en-US" branch="index" id="bm_id3146106"><bookmark_value>IMPOWER function</bookmark_value> 81</bookmark> 82<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMPOWER" id="bm_id3155755" localize="false"/> 83<paragraph xml-lang="en-US" id="hd_id3146106" role="heading" level="2" oldref="58">IMPOWER</paragraph> 84 <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> 85 <paragraph xml-lang="en-US" id="hd_id3150954" role="heading" level="3" l10n="U" 86 oldref="60">Syntax</paragraph> 87 <paragraph xml-lang="en-US" id="par_id3147501" role="code" l10n="U" oldref="61">IMPOWER("ComplexNumber"; Number)</paragraph> 88 <embed href="text/scalc/01/04060116.xhp#complex"/> 89 <paragraph xml-lang="en-US" id="par_id3155743" role="paragraph" l10n="U" oldref="63"> 90 <emph>Number</emph> is the exponent.</paragraph> 91 <paragraph xml-lang="en-US" id="hd_id3149048" role="heading" level="3" l10n="U" 92 oldref="64">Example</paragraph> 93 <paragraph xml-lang="en-US" id="par_id3151393" role="paragraph" l10n="U" oldref="65"> 94 <item type="input">=IMPOWER("2+3i";2)</item> returns -5+12i.</paragraph> 95 </section> 96 <section id="imargument"> 97<bookmark xml-lang="en-US" branch="index" id="bm_id3148748"><bookmark_value>IMARGUMENT function</bookmark_value> 98</bookmark> 99<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMARGUMENT" id="bm_id3147297" localize="false"/> 100<paragraph xml-lang="en-US" id="hd_id3148748" role="heading" level="2" oldref="66">IMARGUMENT</paragraph> 101 <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> 102 <paragraph xml-lang="en-US" id="hd_id3150533" role="heading" level="3" l10n="U" 103 oldref="68">Syntax</paragraph> 104 <paragraph xml-lang="en-US" id="par_id3156402" role="code" l10n="U" oldref="69">IMARGUMENT("ComplexNumber")</paragraph> 105 <embed href="text/scalc/01/04060116.xhp#complex"/> 106 <paragraph xml-lang="en-US" id="hd_id3153019" role="heading" level="3" l10n="U" 107 oldref="71">Example</paragraph> 108 <paragraph xml-lang="en-US" id="par_id3159125" role="paragraph" l10n="U" oldref="72"> 109 <item type="input">=IMARGUMENT("3+4j")</item> returns 0.927295.</paragraph> 110 </section> 111 <section id="imcos"> 112<bookmark xml-lang="en-US" branch="index" id="bm_id3149146"><bookmark_value>IMCOS function</bookmark_value> 113</bookmark> 114<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCOS" id="bm_id3150378" localize="false"/> 115<paragraph xml-lang="en-US" id="hd_id3149146" role="heading" level="2" oldref="73">IMCOS</paragraph> 116 <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> 117 <paragraph xml-lang="en-US" id="hd_id3159116" role="heading" level="3" l10n="U" 118 oldref="75">Syntax</paragraph> 119 <paragraph xml-lang="en-US" id="par_id3147415" role="code" l10n="U" oldref="76">IMCOS("ComplexNumber")</paragraph> 120 <embed href="text/scalc/01/04060116.xhp#complex"/> 121 <paragraph xml-lang="en-US" id="hd_id3152980" role="heading" level="3" l10n="U" 122 oldref="78">Example</paragraph> 123 <paragraph xml-lang="en-US" id="par_id3157901" role="paragraph" l10n="U" oldref="79"> 124 <item type="input">=IMCOS("3+4j") </item>returns -27.03-3.85j (rounded).</paragraph> 125 </section> 126 <section id="imcosh"> 127<bookmark xml-lang="en-US" branch="index" id="bm_id3149148"><bookmark_value>IMCOSH function</bookmark_value> 128</bookmark> 129<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCOS" id="bm_id3150380" localize="false"/> 130<paragraph xml-lang="en-US" id="hd_id3149148" role="heading" level="2" oldref="">IMCOSH</paragraph> 131 <paragraph xml-lang="en-US" id="par_id3149727" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMCOSH">The result is the hyberbolic cosine of a complex number.</ahelp></paragraph> 132 <paragraph xml-lang="en-US" id="hd_id3159118" role="heading" level="3" l10n="New" 133 oldref="">Syntax</paragraph> 134 <paragraph xml-lang="en-US" id="par_id3147417" role="code" l10n="New" oldref="">IMCOSH("ComplexNumber")</paragraph> 135 <embed href="text/scalc/01/04060116.xhp#complex"/> 136 <paragraph xml-lang="en-US" id="hd_id3152982" role="heading" level="3" l10n="New" 137 oldref="">Example</paragraph> 138 <paragraph xml-lang="en-US" id="par_id3157903" role="paragraph" l10n="New" oldref=""> 139 <item type="input">=IMCOSH("3+4j") </item>returns -6.58066304-7.58155274j (rounded).</paragraph> 140 </section> 141 <section id="imcot"> 142<bookmark xml-lang="en-US" branch="index" id="bm_id3149149"><bookmark_value>IMCOT function</bookmark_value> 143</bookmark> 144<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCOT" id="bm_id3150381" localize="false"/> 145<paragraph xml-lang="en-US" id="hd_id3149149" role="heading" level="2" oldref="">IMCOT</paragraph> 146 <paragraph xml-lang="en-US" id="par_id3149728" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMCOT">The result is the cotangent of a complex number.</ahelp></paragraph> 147 <paragraph xml-lang="en-US" id="hd_id3159119" role="heading" level="3" l10n="New" 148 oldref="">Syntax</paragraph> 149 <paragraph xml-lang="en-US" id="par_id3147418" role="code" l10n="New" oldref="">IMCOT("ComplexNumber")</paragraph> 150 <embed href="text/scalc/01/04060116.xhp#complex"/> 151 <paragraph xml-lang="en-US" id="hd_id3152983" role="heading" level="3" l10n="New" 152 oldref="">Example</paragraph> 153 <paragraph xml-lang="en-US" id="par_id3157904" role="paragraph" l10n="New" oldref=""> 154 <item type="input">=IMCOT("3+4j") </item>returns -0.00018759-1.00064439j (rounded).</paragraph> 155 </section> 156 <section id="imcsc"> 157<bookmark xml-lang="en-US" branch="index" id="bm_id3149147"><bookmark_value>IMCSC function</bookmark_value> 158</bookmark> 159<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCSC" id="bm_id3150379" localize="false"/> 160<paragraph xml-lang="en-US" id="hd_id3149147" role="heading" level="2" oldref="">IMCSC</paragraph> 161 <paragraph xml-lang="en-US" id="par_id3149726" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMCSC">The result is the cosecant of a complex number.</ahelp></paragraph> 162 <paragraph xml-lang="en-US" id="hd_id3159117" role="heading" level="3" l10n="New" 163 oldref="">Syntax</paragraph> 164 <paragraph xml-lang="en-US" id="par_id3147416" role="code" l10n="New" oldref="">IMCSC("ComplexNumber")</paragraph> 165 <embed href="text/scalc/01/04060116.xhp#complex"/> 166 <paragraph xml-lang="en-US" id="hd_id3152981" role="heading" level="3" l10n="New" 167 oldref="">Example</paragraph> 168 <paragraph xml-lang="en-US" id="par_id3157902" role="paragraph" l10n="New" oldref=""> 169 <item type="input">=IMCSC("3+4j") </item>returns 0.00517447+0.03627589j (rounded).</paragraph> 170 </section> 171 <section id="imcsch"> 172<bookmark xml-lang="en-US" branch="index" id="bm_id3149150"><bookmark_value>IMCSCH function</bookmark_value> 173</bookmark> 174<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCSCH" id="bm_id3150382" localize="false"/> 175<paragraph xml-lang="en-US" id="hd_id3149150" role="heading" level="2" oldref="">IMCSCH</paragraph> 176 <paragraph xml-lang="en-US" id="par_id3149729" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMCSCH">The result is the hyperbolic cosecant of a complex number.</ahelp></paragraph> 177 <paragraph xml-lang="en-US" id="hd_id3159120" role="heading" level="3" l10n="New" 178 oldref="">Syntax</paragraph> 179 <paragraph xml-lang="en-US" id="par_id3147419" role="code" l10n="New" oldref="">IMCSCH("ComplexNumber")</paragraph> 180 <embed href="text/scalc/01/04060116.xhp#complex"/> 181 <paragraph xml-lang="en-US" id="hd_id3152984" role="heading" level="3" l10n="New" 182 oldref="">Example</paragraph> 183 <paragraph xml-lang="en-US" id="par_id3157905" role="paragraph" l10n="New" oldref=""> 184 <item type="input">=IMCSCH("3+4j") </item>returns -1.30632891+1.51251400j (rounded). </paragraph> 185 </section> 186 <section id="imdiv"> 187<bookmark xml-lang="en-US" branch="index" id="bm_id3150024"><bookmark_value>IMDIV function</bookmark_value> 188</bookmark> 189<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMDIV" id="bm_id3154679" localize="false"/> 190<paragraph xml-lang="en-US" id="hd_id3150024" role="heading" level="2" oldref="80">IMDIV</paragraph> 191 <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> 192 <paragraph xml-lang="en-US" id="hd_id3150465" role="heading" level="3" l10n="U" 193 oldref="82">Syntax</paragraph> 194 <paragraph xml-lang="en-US" id="par_id3146942" role="code" l10n="U" oldref="83">IMDIV("Numerator"; "Denominator")</paragraph> 195 <paragraph xml-lang="en-US" id="par_id3150741" role="paragraph" l10n="CHG" oldref="84"> 196 <emph>Numerator</emph>, <emph>Denominator</emph> are complex numbers that are entered in the form "x+yi" or "x+yj".</paragraph> 197 <paragraph xml-lang="en-US" id="hd_id3151229" role="heading" level="3" l10n="U" 198 oldref="85">Example</paragraph> 199 <paragraph xml-lang="en-US" id="par_id3148440" role="paragraph" l10n="U" oldref="86"> 200 <item type="input">=IMDIV("-238+240i";"10+24i")</item> returns 5+12i.</paragraph> 201 </section> 202 <section id="imexp"> 203<bookmark xml-lang="en-US" branch="index" id="bm_id3153039"><bookmark_value>IMEXP function</bookmark_value> 204</bookmark> 205<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMEXP" id="bm_id3147468" localize="false"/> 206<paragraph xml-lang="en-US" id="hd_id3153039" role="heading" level="2" oldref="87">IMEXP</paragraph> 207 <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> 208 <paragraph xml-lang="en-US" id="hd_id3145591" role="heading" level="3" l10n="U" 209 oldref="89">Syntax</paragraph> 210 <paragraph xml-lang="en-US" id="par_id3154810" role="code" l10n="U" oldref="90">IMEXP("ComplexNumber")</paragraph> 211 <embed href="text/scalc/01/04060116.xhp#complex"/> 212 <paragraph xml-lang="en-US" id="hd_id3148581" role="heading" level="3" l10n="U" 213 oldref="92">Example</paragraph> 214 <paragraph xml-lang="en-US" id="par_id3149253" role="paragraph" l10n="U" oldref="93"> 215 <item type="input">=IMEXP("1+j") </item>returns 1.47+2.29j (rounded).</paragraph> 216 </section> 217 <section id="imconjugate"> 218<bookmark xml-lang="en-US" branch="index" id="bm_id3149955"><bookmark_value>IMCONJUGATE function</bookmark_value> 219</bookmark> 220<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMCONJUGATE" id="bm_id3152782" localize="false"/> 221<paragraph xml-lang="en-US" id="hd_id3149955" role="heading" level="2" oldref="94">IMCONJUGATE</paragraph> 222 <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> 223 <paragraph xml-lang="en-US" id="hd_id3148750" role="heading" level="3" l10n="U" 224 oldref="96">Syntax</paragraph> 225 <paragraph xml-lang="en-US" id="par_id3153082" role="code" l10n="U" oldref="97">IMCONJUGATE("ComplexNumber")</paragraph> 226 <embed href="text/scalc/01/04060116.xhp#complex"/> 227 <paragraph xml-lang="en-US" id="hd_id3153326" role="heading" level="3" l10n="U" 228 oldref="99">Example</paragraph> 229 <paragraph xml-lang="en-US" id="par_id3149688" role="paragraph" l10n="U" oldref="100"> 230 <item type="input">=IMCONJUGATE("1+j")</item> returns 1-j.</paragraph> 231 </section> 232 <section id="imln"> 233<bookmark xml-lang="en-US" branch="index" id="bm_id3150898"><bookmark_value>IMLN function</bookmark_value> 234</bookmark> 235<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMLN" id="bm_id3149190" localize="false"/> 236<paragraph xml-lang="en-US" id="hd_id3150898" role="heading" level="2" oldref="101">IMLN</paragraph> 237 <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> 238 <paragraph xml-lang="en-US" id="hd_id3150008" role="heading" level="3" l10n="U" 239 oldref="103">Syntax</paragraph> 240 <paragraph xml-lang="en-US" id="par_id3155954" role="code" l10n="U" oldref="104">IMLN("ComplexNumber")</paragraph> 241 <embed href="text/scalc/01/04060116.xhp#complex"/> 242 <paragraph xml-lang="en-US" id="hd_id3153565" role="heading" level="3" l10n="U" 243 oldref="106">Example</paragraph> 244 <paragraph xml-lang="en-US" id="par_id3153736" role="paragraph" l10n="U" oldref="107"> 245 <item type="input">=IMLN("1+j")</item> returns 0.35+0.79j (rounded).</paragraph> 246 </section> 247 <section id="imlog10"> 248<bookmark xml-lang="en-US" branch="index" id="bm_id3155929"><bookmark_value>IMLOG10 function</bookmark_value> 249</bookmark> 250<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMLOG10" id="bm_id3148765" localize="false"/> 251<paragraph xml-lang="en-US" id="hd_id3155929" role="heading" level="2" oldref="108">IMLOG10</paragraph> 252 <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> 253 <paragraph xml-lang="en-US" id="hd_id3154327" role="heading" level="3" l10n="U" 254 oldref="110">Syntax</paragraph> 255 <paragraph xml-lang="en-US" id="par_id3150128" role="code" l10n="U" oldref="111">IMLOG10("ComplexNumber")</paragraph> 256 <embed href="text/scalc/01/04060116.xhp#complex"/> 257 <paragraph xml-lang="en-US" id="hd_id3149003" role="heading" level="3" l10n="U" 258 oldref="113">Example</paragraph> 259 <paragraph xml-lang="en-US" id="par_id3151021" role="paragraph" l10n="U" oldref="114"> 260 <item type="input">=IMLOG10("1+j")</item> returns 0.15+0.34j (rounded).</paragraph> 261 </section> 262 <section id="imlog2"> 263<bookmark xml-lang="en-US" branch="index" id="bm_id3155623"><bookmark_value>IMLOG2 function</bookmark_value> 264</bookmark> 265<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMLOG2" id="bm_id3157975" localize="false"/> 266<paragraph xml-lang="en-US" id="hd_id3155623" role="heading" level="2" oldref="115">IMLOG2</paragraph> 267 <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> 268 <paragraph xml-lang="en-US" id="hd_id3153046" role="heading" level="3" l10n="U" 269 oldref="117">Syntax</paragraph> 270 <paragraph xml-lang="en-US" id="par_id3145355" role="code" l10n="U" oldref="118">IMLOG2("ComplexNumber")</paragraph> 271 <embed href="text/scalc/01/04060116.xhp#complex"/> 272 <paragraph xml-lang="en-US" id="hd_id3148768" role="heading" level="3" l10n="U" 273 oldref="120">Example</paragraph> 274 <paragraph xml-lang="en-US" id="par_id3149536" role="paragraph" l10n="U" oldref="121"> 275 <item type="input">=IMLOG2("1+j")</item> returns 0.50+1.13j (rounded).</paragraph> 276 </section> 277 <section id="improduct"> 278<bookmark xml-lang="en-US" branch="index" id="bm_id3145626"><bookmark_value>IMPRODUCT function</bookmark_value> 279</bookmark> 280<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMPRODUCT" id="bm_id3150661" localize="false"/> 281<paragraph xml-lang="en-US" id="hd_id3145626" role="heading" level="2" oldref="122">IMPRODUCT</paragraph> 282 <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> 283 <paragraph xml-lang="en-US" id="hd_id3149388" role="heading" level="3" l10n="U" 284 oldref="124">Syntax</paragraph> 285 <paragraph xml-lang="en-US" id="par_id3149027" role="code" l10n="U" oldref="125">IMPRODUCT("ComplexNumber"; "ComplexNumber1"; ...)</paragraph> 286 <embed href="text/scalc/01/04060116.xhp#complex"/> 287 <paragraph xml-lang="en-US" id="hd_id3153228" role="heading" level="3" l10n="U" 288 oldref="127">Example</paragraph> 289 <paragraph xml-lang="en-US" id="par_id3155815" role="paragraph" l10n="U" oldref="128"> 290 <item type="input">=IMPRODUCT("3+4j";"5-3j")</item> returns 27+11j.</paragraph> 291 </section> 292 <section id="imreal"> 293<bookmark xml-lang="en-US" branch="index" id="bm_id3147539"><bookmark_value>IMREAL function</bookmark_value> 294</bookmark> 295<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMREAL" id="bm_id3148596" localize="false"/> 296<paragraph xml-lang="en-US" id="hd_id3147539" role="heading" level="2" oldref="129">IMREAL</paragraph> 297 <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> 298 <paragraph xml-lang="en-US" id="hd_id3154951" role="heading" level="3" l10n="U" 299 oldref="131">Syntax</paragraph> 300 <paragraph xml-lang="en-US" id="par_id3153927" role="code" l10n="U" oldref="132">IMREAL("ComplexNumber")</paragraph> 301 <embed href="text/scalc/01/04060116.xhp#complex"/> 302 <paragraph xml-lang="en-US" id="hd_id3155409" role="heading" level="3" l10n="U" 303 oldref="134">Example</paragraph> 304 <paragraph xml-lang="en-US" id="par_id3155986" role="paragraph" l10n="U" oldref="135"> 305 <item type="input">=IMREAL("1+3j")</item> returns 1.</paragraph> 306 </section> 307 <section id="imsec"> 308<bookmark xml-lang="en-US" branch="index" id="bm_id3148430"><bookmark_value>IMSEC function</bookmark_value> 309</bookmark> 310<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSEC" id="bm_id3153715" localize="false"/> 311<paragraph xml-lang="en-US" id="hd_id3148430" role="heading" level="2" oldref="">IMSEC</paragraph> 312 <paragraph xml-lang="en-US" id="par_id3152590" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMSEC">The result is the secant of a complex number.</ahelp></paragraph> 313 <paragraph xml-lang="en-US" id="hd_id3149821" role="heading" level="3" l10n="New" 314 oldref="">Syntax</paragraph> 315 <paragraph xml-lang="en-US" id="par_id3150386" role="code" l10n="New" oldref="">IMSEC("ComplexNumber")</paragraph> 316 <embed href="text/scalc/01/04060116.xhp#complex"/> 317 <paragraph xml-lang="en-US" id="hd_id3150612" role="heading" level="3" l10n="New" 318 oldref="">Example</paragraph> 319 <paragraph xml-lang="en-US" id="par_id3154309" role="paragraph" l10n="New" oldref=""> 320 <item type="input">=IMSEC("3+4j")</item> returns -0.03625350+0.00516434j (rounded).</paragraph> 321 </section> 322 <section id="imsech"> 323<bookmark xml-lang="en-US" branch="index" id="bm_id3148432"><bookmark_value>IMSECH function</bookmark_value> 324</bookmark> 325<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSECH" id="bm_id3153717" localize="false"/> 326<paragraph xml-lang="en-US" id="hd_id3148432" role="heading" level="2" oldref="">IMSECH</paragraph> 327 <paragraph xml-lang="en-US" id="par_id3152592" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMSECH">The result is the hyperbolic secant of a complex number.</ahelp></paragraph> 328 <paragraph xml-lang="en-US" id="hd_id3149823" role="heading" level="3" l10n="New" 329 oldref="">Syntax</paragraph> 330 <paragraph xml-lang="en-US" id="par_id3150388" role="code" l10n="New" oldref="">IMSECH("ComplexNumber")</paragraph> 331 <embed href="text/scalc/01/04060116.xhp#complex"/> 332 <paragraph xml-lang="en-US" id="hd_id3150614" role="heading" level="3" l10n="New" 333 oldref="">Example</paragraph> 334 <paragraph xml-lang="en-US" id="par_id3154311" role="paragraph" l10n="New" oldref=""> 335 <item type="input">=IMSECH("3+4j")</item> returns -1.30823089+1.51467895j (rounded).</paragraph> 336 </section> 337 <section id="imsin"> 338<bookmark xml-lang="en-US" branch="index" id="bm_id3148431"><bookmark_value>IMSIN function</bookmark_value> 339</bookmark> 340<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSIN" id="bm_id3153716" localize="false"/> 341<paragraph xml-lang="en-US" id="hd_id3148431" role="heading" level="2" oldref="136">IMSIN</paragraph> 342 <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> 343 <paragraph xml-lang="en-US" id="hd_id3149822" role="heading" level="3" l10n="U" 344 oldref="138">Syntax</paragraph> 345 <paragraph xml-lang="en-US" id="par_id3150387" role="code" l10n="U" oldref="139">IMSIN("ComplexNumber")</paragraph> 346 <embed href="text/scalc/01/04060116.xhp#complex"/> 347 <paragraph xml-lang="en-US" id="hd_id3150613" role="heading" level="3" l10n="U" 348 oldref="141">Example</paragraph> 349 <paragraph xml-lang="en-US" id="par_id3154310" role="paragraph" l10n="U" oldref="142"> 350 <item type="input">=IMSIN("3+4j")</item> returns 3.85+27.02j (rounded).</paragraph> 351 </section> 352 <section id="imsinh"> 353<bookmark xml-lang="en-US" branch="index" id="bm_id3148433"><bookmark_value>IMSINH function</bookmark_value> 354</bookmark> 355<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSINH" id="bm_id3153718" localize="false"/> 356<paragraph xml-lang="en-US" id="hd_id3148433" role="heading" level="2" oldref="">IMSINH</paragraph> 357 <paragraph xml-lang="en-US" id="par_id3152593" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMSINH">The result is the hyperbolic sine of a complex number.</ahelp></paragraph> 358 <paragraph xml-lang="en-US" id="hd_id3149824" role="heading" level="3" l10n="New" 359 oldref="">Syntax</paragraph> 360 <paragraph xml-lang="en-US" id="par_id3150389" role="code" l10n="New" oldref="">IMSINH("ComplexNumber")</paragraph> 361 <embed href="text/scalc/01/04060116.xhp#complex"/> 362 <paragraph xml-lang="en-US" id="hd_id3150615" role="heading" level="3" l10n="New" 363 oldref="">Example</paragraph> 364 <paragraph xml-lang="en-US" id="par_id3154312" role="paragraph" l10n="New" oldref=""> 365 <item type="input">=IMSINH("3+4j")</item> returns -6.54812004-7.61923172j (rounded).</paragraph> 366 </section> 367 <section id="imsub"> 368<bookmark xml-lang="en-US" branch="index" id="bm_id3163826"><bookmark_value>IMSUB function</bookmark_value> 369</bookmark> 370<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSUB" id="bm_id3152481" localize="false"/> 371<paragraph xml-lang="en-US" id="hd_id3163826" role="heading" level="2" oldref="143">IMSUB</paragraph> 372 <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> 373 <paragraph xml-lang="en-US" id="hd_id3149264" role="heading" level="3" l10n="U" 374 oldref="145">Syntax</paragraph> 375 <paragraph xml-lang="en-US" id="par_id3149710" role="code" l10n="U" oldref="146">IMSUB("ComplexNumber1"; "ComplexNumber2")</paragraph> 376 <embed href="text/scalc/01/04060116.xhp#complex"/> 377 <paragraph xml-lang="en-US" id="hd_id3155833" role="heading" level="3" l10n="U" 378 oldref="148">Example</paragraph> 379 <paragraph xml-lang="en-US" id="par_id3150963" role="paragraph" l10n="U" oldref="149"> 380 <item type="input">=IMSUB("13+4j";"5+3j")</item> returns 8+j.</paragraph> 381 </section> 382 <section id="imsum"> 383<bookmark xml-lang="en-US" branch="index" id="bm_id3156312"><bookmark_value>IMSUM function</bookmark_value> 384</bookmark> 385<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSUM" id="bm_id3149454" localize="false"/> 386<paragraph xml-lang="en-US" id="hd_id3156312" role="heading" level="2" oldref="150">IMSUM</paragraph> 387 <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> 388 <paragraph xml-lang="en-US" id="hd_id3156095" role="heading" level="3" l10n="U" 389 oldref="152">Syntax</paragraph> 390 <paragraph xml-lang="en-US" id="par_id3152930" role="code" l10n="U" oldref="153">IMSUM("ComplexNumber1"; "ComplexNumber2"; ...)</paragraph> 391 <embed href="text/scalc/01/04060116.xhp#complex"/> 392 <paragraph xml-lang="en-US" id="hd_id3154640" role="heading" level="3" l10n="U" 393 oldref="155">Example</paragraph> 394 <paragraph xml-lang="en-US" id="par_id3147081" role="paragraph" l10n="U" oldref="156"> 395 <item type="input">=IMSUM("13+4j";"5+3j")</item> returns 18+7j.</paragraph> 396 </section> 397 <section id="imsqrt"> 398<bookmark xml-lang="en-US" branch="index" id="bm_id3147570"><bookmark_value>IMSQRT function</bookmark_value> 399</bookmark> 400<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMSQRT" id="bm_id3151189" localize="false"/> 401<paragraph xml-lang="en-US" id="hd_id3147570" role="heading" level="2" oldref="167">IMSQRT</paragraph> 402 <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> 403 <paragraph xml-lang="en-US" id="hd_id3145202" role="heading" level="3" l10n="U" 404 oldref="169">Syntax</paragraph> 405 <paragraph xml-lang="en-US" id="par_id3150760" role="code" l10n="U" oldref="170">IMSQRT("ComplexNumber")</paragraph> 406 <embed href="text/scalc/01/04060116.xhp#complex"/> 407 <paragraph xml-lang="en-US" id="hd_id3147268" role="heading" level="3" l10n="U" 408 oldref="172">Example</paragraph> 409 <paragraph xml-lang="en-US" id="par_id3152807" role="paragraph" l10n="U" oldref="173"> 410 <item type="input">=IMSQRT("3+4i")</item> returns 2+1i.</paragraph> 411 </section> 412 <section id="imtan"> 413<bookmark xml-lang="en-US" branch="index" id="bm_id3149151"><bookmark_value>IMTAN function</bookmark_value> 414</bookmark> 415<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_IMTAN" id="bm_id3150383" localize="false"/> 416<paragraph xml-lang="en-US" id="hd_id3149151" role="heading" level="2" oldref="">IMTAN</paragraph> 417 <paragraph xml-lang="en-US" id="par_id3149730" role="paragraph" l10n="New" oldref=""><ahelp hid="HID_AAI_FUNC_IMTAN">The result is the tangent of a complex number.</ahelp></paragraph> 418 <paragraph xml-lang="en-US" id="hd_id3159121" role="heading" level="3" l10n="New" 419 oldref="">Syntax</paragraph> 420 <paragraph xml-lang="en-US" id="par_id3147420" role="code" l10n="New" oldref="">IMTAN("ComplexNumber")</paragraph> 421 <embed href="text/scalc/01/04060116.xhp#complex"/> 422 <paragraph xml-lang="en-US" id="hd_id3152985" role="heading" level="3" l10n="New" 423 oldref="">Example</paragraph> 424 <paragraph xml-lang="en-US" id="par_id3157906" role="paragraph" l10n="New" oldref=""> 425 <item type="input">=IMTAN("3+4j") </item>returns -0.00018734+0.99935599j (rounded).</paragraph> 426 </section> 427 <section id="complexfunc"> 428<bookmark xml-lang="en-US" branch="index" id="bm_id3154054"><bookmark_value>COMPLEX function</bookmark_value> 429</bookmark> 430<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_COMPLEX" id="bm_id3156116" localize="false"/> 431<paragraph xml-lang="en-US" id="hd_id3154054" role="heading" level="2" oldref="157">COMPLEX</paragraph> 432 <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> 433 <paragraph xml-lang="en-US" id="hd_id3154744" role="heading" level="3" l10n="U" 434 oldref="159">Syntax</paragraph> 435 <paragraph xml-lang="en-US" id="par_id3155999" role="code" l10n="U" oldref="160">COMPLEX(RealNum; INum; Suffix)</paragraph> 436 <paragraph xml-lang="en-US" id="par_id3153626" role="paragraph" l10n="U" oldref="161"> 437 <emph>RealNum</emph> is the real coefficient of the complex number.</paragraph> 438 <paragraph xml-lang="en-US" id="par_id3149135" role="paragraph" l10n="U" oldref="162"> 439 <emph>INum</emph> is the imaginary coefficient of the complex number.</paragraph> 440 <paragraph xml-lang="en-US" id="par_id3155849" role="paragraph" l10n="U" oldref="163"> 441 <emph>Suffix</emph> is a list of options, "i" or "j".</paragraph> 442 <paragraph xml-lang="en-US" id="hd_id3145659" role="heading" level="3" l10n="U" 443 oldref="164">Example</paragraph> 444 <paragraph xml-lang="en-US" id="par_id3143229" role="paragraph" l10n="U" oldref="165"> 445 <item type="input">=COMPLEX(3;4;"j")</item> returns 3+4j.</paragraph> 446 </section> 447 <section id="oct2bin"> 448<bookmark xml-lang="en-US" branch="index" id="bm_id3155103"><bookmark_value>OCT2BIN function</bookmark_value> 449 <bookmark_value>converting;octal numbers, into binary numbers</bookmark_value> 450</bookmark><comment>mw added one entry</comment> 451<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_OCT2BIN" id="bm_id3149290" localize="false"/> 452<paragraph xml-lang="en-US" id="hd_id3155103" role="heading" level="2" l10n="E" 453 oldref="217">OCT2BIN</paragraph> 454 <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> 455 <paragraph xml-lang="en-US" id="hd_id3146088" role="heading" level="3" l10n="U" 456 oldref="219">Syntax</paragraph> 457 <paragraph xml-lang="en-US" id="par_id3154303" role="code" l10n="U" oldref="220">OCT2BIN(Number; Places)</paragraph> 458 <paragraph xml-lang="en-US" id="par_id3156013" role="paragraph" l10n="U" oldref="221"> 459 <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> 460 <paragraph xml-lang="en-US" id="par_id3153984" role="paragraph" l10n="U" oldref="222"> 461 <emph>Places</emph> is the number of places to be output.</paragraph> 462 <paragraph xml-lang="en-US" id="hd_id3147493" role="heading" level="3" l10n="U" 463 oldref="223">Example</paragraph> 464 <paragraph xml-lang="en-US" id="par_id3147260" role="paragraph" l10n="U" oldref="224"> 465 <item type="input">=OCT2BIN(3;3)</item> returns 011.</paragraph> 466 </section> 467 <section id="oct2dec"> 468<bookmark xml-lang="en-US" branch="index" id="bm_id3152791"><bookmark_value>OCT2DEC function</bookmark_value> 469 <bookmark_value>converting;octal numbers, into decimal numbers</bookmark_value> 470</bookmark><comment>mw added one entry</comment> 471<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_OCT2DEZ" id="bm_id3151168" localize="false"/> 472<paragraph xml-lang="en-US" id="hd_id3152791" role="heading" level="2" oldref="225">OCT2DEC</paragraph> 473 <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> 474 <paragraph xml-lang="en-US" id="hd_id3159337" role="heading" level="3" l10n="U" 475 oldref="227">Syntax</paragraph> 476 <paragraph xml-lang="en-US" id="par_id3153902" role="code" l10n="U" oldref="228">OCT2DEC(Number)</paragraph> 477 <paragraph xml-lang="en-US" id="par_id3155326" role="paragraph" l10n="U" oldref="229"> 478 <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> 479 <paragraph xml-lang="en-US" id="hd_id3154698" role="heading" level="3" l10n="U" 480 oldref="230">Example</paragraph> 481 <paragraph xml-lang="en-US" id="par_id3154930" role="paragraph" l10n="U" oldref="231"> 482 <item type="input">=OCT2DEC(144)</item> returns 100.</paragraph> 483 </section> 484 <section id="oct2hex"> 485<bookmark xml-lang="en-US" branch="index" id="bm_id3155391"><bookmark_value>OCT2HEX function</bookmark_value> 486 <bookmark_value>converting;octal numbers, into hexadecimal numbers</bookmark_value> 487</bookmark><comment>mw added one entry</comment> 488<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_OCT2HEX" id="bm_id3149904" localize="false"/> 489<paragraph xml-lang="en-US" id="hd_id3155391" role="heading" level="2" oldref="232">OCT2HEX</paragraph> 490 <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> 491 <paragraph xml-lang="en-US" id="hd_id3146988" role="heading" level="3" l10n="U" 492 oldref="234">Syntax</paragraph> 493 <paragraph xml-lang="en-US" id="par_id3150523" role="code" l10n="U" oldref="235">OCT2HEX(Number; Places)</paragraph> 494 <paragraph xml-lang="en-US" id="par_id3159162" role="paragraph" l10n="U" oldref="236"> 495 <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> 496 <paragraph xml-lang="en-US" id="par_id3145420" role="paragraph" l10n="U" oldref="237"> 497 <emph>Places</emph> is the number of places to be output.</paragraph> 498 <paragraph xml-lang="en-US" id="hd_id3150504" role="heading" level="3" l10n="U" 499 oldref="238">Example</paragraph> 500 <paragraph xml-lang="en-US" id="par_id3148802" role="paragraph" l10n="U" oldref="239"> 501 <item type="input">=OCT2HEX(144;4)</item> returns 0064.</paragraph> 502 </section> 503 <section id="convertadd"> 504<bookmark xml-lang="en-US" branch="index" id="bm_id3148446"><bookmark_value>CONVERT_ADD function</bookmark_value> 505</bookmark> 506<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_CONVERT" id="bm_id3150773" localize="false"/> 507<paragraph xml-lang="en-US" id="hd_id3148446" role="heading" level="2" l10n="CHG" 508 oldref="175">CONVERT_ADD</paragraph> 509 <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> 510 <table id="tbl_id3149771"> 511 <tablerow> 512 <tablecell> 513 <paragraph xml-lang="en-US" id="par_id3153055" role="tablehead" l10n="U" oldref="177">Property</paragraph> 514 </tablecell> 515 <tablecell> 516 <paragraph xml-lang="en-US" id="par_id3147234" role="tablehead" l10n="U" oldref="178">Units</paragraph> 517 </tablecell> 518 </tablerow> 519 <tablerow> 520 <tablecell> 521 <paragraph xml-lang="en-US" id="par_id3147512" role="tablecontent" l10n="U" oldref="179">Weight</paragraph> 522 </tablecell> 523 <tablecell> 524 <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> 525 </tablecell> 526 </tablerow> 527 <tablerow> 528 <tablecell> 529 <paragraph xml-lang="en-US" id="par_id3155361" role="tablecontent" l10n="U" oldref="181">Length</paragraph> 530 </tablecell> 531 <tablecell> 532 <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> 533 </tablecell> 534 </tablerow> 535 <tablerow> 536 <tablecell> 537 <paragraph xml-lang="en-US" id="par_id3158429" role="tablecontent" l10n="U" oldref="183">Time</paragraph> 538 </tablecell> 539 <tablecell> 540 <paragraph xml-lang="en-US" id="par_id3150707" role="tablecontent" l10n="U" oldref="184">yr, day, hr, mn, sec</paragraph> 541 </tablecell> 542 </tablerow> 543 <tablerow> 544 <tablecell> 545 <paragraph xml-lang="en-US" id="par_id3153238" role="tablecontent" l10n="U" oldref="185">Pressure</paragraph> 546 </tablecell> 547 <tablecell> 548 <paragraph xml-lang="en-US" id="par_id3166437" role="tablecontent" l10n="U" oldref="186">Pa, atm, mmHg, Torr, psi</paragraph> 549 </tablecell> 550 </tablerow> 551 <tablerow> 552 <tablecell> 553 <paragraph xml-lang="en-US" id="par_id3152944" role="tablecontent" l10n="U" oldref="187">Force</paragraph> 554 </tablecell> 555 <tablecell> 556 <paragraph xml-lang="en-US" id="par_id3155582" role="tablecontent" l10n="U" oldref="188">N, dyn, pond</paragraph> 557 </tablecell> 558 </tablerow> 559 <tablerow> 560 <tablecell> 561 <paragraph xml-lang="en-US" id="par_id3153686" role="tablecontent" l10n="U" oldref="189">Energy</paragraph> 562 </tablecell> 563 <tablecell> 564 <paragraph xml-lang="en-US" id="par_id3153386" role="tablecontent" l10n="U" oldref="190">J, e, c, cal, eV, HPh, Wh, BTU</paragraph> 565 </tablecell> 566 </tablerow> 567 <tablerow> 568 <tablecell> 569 <paragraph xml-lang="en-US" id="par_id3154100" role="tablecontent" l10n="U" oldref="191">Power</paragraph> 570 </tablecell> 571 <tablecell> 572 <paragraph xml-lang="en-US" id="par_id3149915" role="tablecontent" l10n="U" oldref="192">W, HP, PS</paragraph> 573 </tablecell> 574 </tablerow> 575 <tablerow> 576 <tablecell> 577 <paragraph xml-lang="en-US" id="par_id3148988" role="tablecontent" l10n="U" oldref="193">Field strength</paragraph> 578 </tablecell> 579 <tablecell> 580 <paragraph xml-lang="en-US" id="par_id3148616" role="tablecontent" l10n="U" oldref="194">T, ga</paragraph> 581 </tablecell> 582 </tablerow> 583 <tablerow> 584 <tablecell> 585 <paragraph xml-lang="en-US" id="par_id3151120" role="tablecontent" l10n="U" oldref="195">Temperature</paragraph> 586 </tablecell> 587 <tablecell> 588 <paragraph xml-lang="en-US" id="par_id3148659" role="tablecontent" l10n="U" oldref="196">C, F, K, Reau, Rank</paragraph> 589 </tablecell> 590 </tablerow> 591 <tablerow> 592 <tablecell> 593 <paragraph xml-lang="en-US" id="par_id3154610" role="tablecontent" l10n="U" oldref="197">Volume</paragraph> 594 </tablecell> 595 <tablecell> 596 <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> 597 </tablecell> 598 </tablerow> 599 <tablerow> 600 <tablecell> 601 <paragraph xml-lang="en-US" id="par_id3149244" role="tablecontent" l10n="U" oldref="199">Area</paragraph> 602 </tablecell> 603 <tablecell> 604 <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> 605 </tablecell> 606 </tablerow> 607 <tablerow> 608 <tablecell> 609 <paragraph xml-lang="en-US" id="par_id3150629" role="tablecontent" l10n="U" oldref="201">Speed</paragraph> 610 </tablecell> 611 <tablecell> 612 <paragraph xml-lang="en-US" id="par_id3159246" role="tablecontent" l10n="U" oldref="202">m/s, m/h, mph, kn, admkn</paragraph> 613 </tablecell> 614 </tablerow> 615 </table> 616 617 <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> 618 <table id="tbl_id3144759"> 619 <tablerow> 620 <tablecell> 621 <paragraph xml-lang="en-US" id="par_id3148422" role="tablehead" l10n="U" oldref="204">Permitted prefix characters</paragraph> 622 </tablecell> 623 <tablecell> 624</tablecell> 625 </tablerow> 626 <tablerow> 627 <tablecell> 628 <paragraph xml-lang="en-US" id="par_id3149490" role="tablecontent" l10n="U" oldref="205">10^(<0)</paragraph> 629 </tablecell> 630 <tablecell> 631 <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> 632 </tablecell> 633 </tablerow> 634 <tablerow> 635 <tablecell> 636 <paragraph xml-lang="en-US" id="par_id3149589" role="tablecontent" l10n="U" oldref="207">10^(>0)</paragraph> 637 </tablecell> 638 <tablecell> 639 <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> 640 </tablecell> 641 </tablerow> 642 <tablerow> 643 <tablecell> 644 <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> 645 </tablecell> 646 <tablecell> 647 <paragraph xml-lang="en-US" id="par_id0908200903090966" role="code" l10n="NEW">ki kibi 1024</paragraph> 648 <paragraph xml-lang="en-US" id="par_id0908200903090958" role="code" l10n="NEW">Mi mebi 1048576</paragraph> 649 <paragraph xml-lang="en-US" id="par_id0908200903090936" role="code" l10n="NEW">Gi gibi 1073741824</paragraph> 650 <paragraph xml-lang="en-US" id="par_id0908200903090975" role="code" l10n="NEW">Ti tebi 1099511627776</paragraph> 651 <paragraph xml-lang="en-US" id="par_id0908200903090930" role="code" l10n="NEW">Pi pebi 1125899906842620</paragraph> 652 <paragraph xml-lang="en-US" id="par_id0908200903091070" role="code" l10n="NEW">Ei exbi 1152921504606850000</paragraph> 653 <paragraph xml-lang="en-US" id="par_id0908200903091097" role="code" l10n="NEW">Zi zebi 1180591620717410000000</paragraph> 654 <paragraph xml-lang="en-US" id="par_id0908200903091010" role="code" l10n="NEW">Yi yobi 1208925819614630000000000</paragraph> 655 </tablecell> 656 </tablerow> 657 </table> 658 <embed href="text/scalc/01/04060102.xhp#ADD_note"/> 659 <paragraph xml-lang="en-US" id="hd_id3146125" role="heading" level="3" l10n="U" 660 oldref="209">Syntax</paragraph> 661 <paragraph xml-lang="en-US" id="par_id3153695" role="code" l10n="U" oldref="210">CONVERT_ADD(Number; "FromUnit"; "ToUnit")</paragraph> 662 <paragraph xml-lang="en-US" id="par_id3147522" role="paragraph" l10n="U" oldref="211"> 663 <emph>Number</emph> is the number to be converted.</paragraph> 664 <paragraph xml-lang="en-US" id="par_id3154472" role="paragraph" l10n="U" oldref="212"> 665 <emph>FromUnit</emph> is the unit from which conversion is taking place.</paragraph> 666 <paragraph xml-lang="en-US" id="par_id3153790" role="paragraph" l10n="U" oldref="213"> 667 <emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type.</paragraph> 668<paragraph xml-lang="en-US" id="par_id09022809540918" role="paragraph" l10n="NEW"><link href="https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_CONVERT_ADD_function">Current list of CONVERT_ADD units in the OpenOffice.org Wiki.</link></paragraph> 669 <paragraph xml-lang="en-US" id="hd_id3156270" role="heading" level="3" l10n="U" 670 oldref="214">Examples</paragraph> 671 <paragraph xml-lang="en-US" id="par_id3156336" role="paragraph" l10n="U" oldref="215"> 672 <item type="input">=CONVERT_ADD(10;"HP";"PS") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS.</paragraph> 673 <paragraph xml-lang="en-US" id="par_id3154834" role="paragraph" l10n="U" oldref="216"> 674 <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> 675 </section> 676 <section id="factdouble"> 677<bookmark xml-lang="en-US" branch="index" id="bm_id3147096"><bookmark_value>FACTDOUBLE function</bookmark_value> 678 <bookmark_value>factorials;numbers with increments of two</bookmark_value> 679</bookmark><comment>mw added one entry</comment> 680<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_FACTDOUBLE" id="bm_id3150950" localize="false"/> 681<paragraph xml-lang="en-US" id="hd_id3147096" role="heading" level="2" oldref="36">FACTDOUBLE</paragraph> 682 <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> 683 <paragraph xml-lang="en-US" id="hd_id3154666" role="heading" level="3" l10n="U" 684 oldref="38">Syntax</paragraph> 685 <paragraph xml-lang="en-US" id="par_id3155121" role="code" l10n="U" oldref="39">FACTDOUBLE(Number)</paragraph> 686 <paragraph xml-lang="en-US" id="par_id3158440" role="paragraph" l10n="CHG" oldref="40">Returns <emph>Number</emph> 687 <emph>!!</emph>, the double factorial of <emph>Number</emph>, where <emph>Number</emph> is an integer greater than or equal to zero.</paragraph> 688 <paragraph xml-lang="en-US" id="par_id2480849" role="paragraph" l10n="NEW">For even numbers FACTDOUBLE(n) returns:</paragraph> 689 <paragraph xml-lang="en-US" id="par_id4181951" role="paragraph" l10n="NEW">2*4*6*8* ... *n</paragraph> 690 <paragraph xml-lang="en-US" id="par_id2927335" role="paragraph" l10n="NEW">For odd numbers FACTDOUBLE(n) returns:</paragraph> 691 <paragraph xml-lang="en-US" id="par_id2107303" role="paragraph" l10n="NEW">1*3*5*7* ... *n</paragraph> 692 <paragraph xml-lang="en-US" id="par_id4071779" role="paragraph" l10n="NEW">FACTDOUBLE(0) returns 1 by definition.</paragraph> 693 <paragraph xml-lang="en-US" id="hd_id3154622" role="heading" level="3" l10n="U" 694 oldref="42">Example</paragraph> 695 <paragraph xml-lang="en-US" id="par_id7844477" role="paragraph" l10n="NEW"> 696 <item type="input">=FACTDOUBLE(5)</item> returns 15.</paragraph> 697 <paragraph xml-lang="en-US" id="par_id3154116" role="paragraph" l10n="U" oldref="43"> 698 <item type="input">=FACTDOUBLE(6)</item> returns 48.</paragraph> 699 <paragraph xml-lang="en-US" id="par_id6478469" role="paragraph" l10n="NEW"> 700 <item type="input">=FACTDOUBLE(0)</item> returns 1.</paragraph><comment>see also FACT, MULTINOMIAL, PRODUCT </comment> 701</section> 702</sort> 703<section id="Section1"> 704 <embed href="text/scalc/01/04060100.xhp#drking"/> 705 </section> 706 </body> 707</helpdocument>