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