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