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