helpcontent2/source/text/swriter/02/14020000.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4
   5 <!--
   6  ***********************************************************************
   7  *
   8  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9  *
  10  * Copyright 2008 by Sun Microsystems, Inc.
  11  *
  12  * OpenOffice.org - a multi-platform office productivity suite
  13  *
  14  * $RCSfile: 14020000.xhp,v $
  15  * $Revision: 1.12 $
  16  *
  17  * This file is part of OpenOffice.org.
  18  *
  19  * OpenOffice.org is free software: you can redistribute it and/or modify
  20  * it under the terms of the GNU Lesser General Public License version 3
  21  * only, as published by the Free Software Foundation.
  22  *
  23  * OpenOffice.org is distributed in the hope that it will be useful,
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  26  * GNU Lesser General Public License version 3 for more details
  27  * (a copy is included in the LICENSE file that accompanied this code).
  28  *
  29  * You should have received a copy of the GNU Lesser General Public License
  30  * version 3 along with OpenOffice.org.  If not, see
  31  * <http://www.openoffice.org/license.html>
  32  * for a copy of the LGPLv3 License.
  33  *
  34  ************************************************************************
  35  -->
  36
  37
  38                 <helpdocument version="1.0">
  39 <meta>
  40 <topic id="textswriter0214020000xml" indexer="include" status="PUBLISH">
  41 <title id="tit" xml-lang="en-US">Formula</title>
  42 <filename>/text/swriter/02/14020000.xhp</filename>
  43 </topic>
  44 </meta>
  45 <body>
  46 <section id="formel">
  47 <bookmark xml-lang="en-US" branch="index" id="bm_id3149687"><bookmark_value>operators; in formulas</bookmark_value>
  48 <bookmark_value>statistical functions</bookmark_value>
  49 <bookmark_value>trigonometric functions</bookmark_value>
  50 <bookmark_value>pages;number of</bookmark_value>
  51 <bookmark_value>variables;document properties</bookmark_value>
  52 <bookmark_value>arithmetical operators in formulas</bookmark_value>
  53 </bookmark>
  54 <bookmark xml-lang="en-US" branch="hid/FN_FORMULA_CALC" id="bm_id3155175" localize="false"/><paragraph role="heading" id="hd_id3149687" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/swriter/02/14020000.xhp" name="Formula">Formula</link></paragraph>
  55 <paragraph role="paragraph" id="par_id3143270" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="FN_FORMULA_CALC">Opens a submenu, from which you can insert a formula into the cell of a table.</ahelp> Place the cursor in a cell in the table or at the position in the document where you want the result to appear. Click the<emph> Formula </emph>icon and choose the desired formula from the submenu.</paragraph>
  56 </section>
  57 <paragraph role="paragraph" id="par_id3149096" xml-lang="en-US" l10n="U" oldref="3">The formula appears in the input line. To specify a range of cells in a table, select the desired cells with the mouse. The corresponding cell references also appear in the input line. Enter additional parameters, as necessary, and click <emph>Apply</emph> to confirm your entry. You can also enter the formula directly if you know the appropriate syntax. This is necessary, for example, in the <link href="text/swriter/01/04090000.xhp" name="Insert Fields"><emph>Insert Fields</emph></link> and <emph>Edit Fields</emph> dialogs.</paragraph>
  58 <section id="syformel">
  59 <table id="tbl_id3153634">
  60 <tablerow>
  61 <tablecell colspan="" rowspan="">
  62 <paragraph role="paragraph" id="par_id3155142" xml-lang="en-US" l10n="E">
  63 <image id="img_id3155148" src="sw/imglst/sc20556.png" width="0.222inch" height="0.222inch"><alt id="alt_id3155148" xml-lang="en-US">Icon</alt>
  64         </image></paragraph>
  65 </tablecell>
  66 <tablecell colspan="" rowspan="">
  67 <paragraph role="paragraph" id="par_id3150113" xml-lang="en-US" l10n="U" oldref="4">Formula</paragraph>
  68 </tablecell>
  69 </tablerow>
  70 </table>
  71 </section>
  72 <paragraph role="heading" id="hd_id3150691" xml-lang="en-US" level="2" l10n="U" oldref="5">Summary of Formula Options</paragraph>
  73 <paragraph role="heading" id="hd_id3155858" xml-lang="en-US" level="3" l10n="U" oldref="6">Basic Calculation Functions</paragraph>
  74 <table id="tbl_id3155870">
  75 <tablerow>
  76 <tablecell colspan="" rowspan="">
  77 <paragraph role="paragraph" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="7">Addition</paragraph>
  78 </tablecell>
  79 <tablecell colspan="" rowspan="">
  80 <paragraph role="paragraph" id="par_id3150563" xml-lang="en-US" l10n="U" oldref="8">+</paragraph>
  81 </tablecell>
  82 <tablecell colspan="" rowspan="">
  83 <paragraph role="paragraph" id="par_id3149831" xml-lang="en-US" l10n="U" oldref="9">Calculates the total.</paragraph>
  84 <paragraph role="paragraph" id="par_id3149845" xml-lang="en-US" l10n="U" oldref="161">Example: &lt;A1&gt; + 8</paragraph>
  85 </tablecell>
  86 </tablerow>
  87 <tablerow>
  88 <tablecell colspan="" rowspan="">
  89 <paragraph role="paragraph" id="par_id3156097" xml-lang="en-US" l10n="U" oldref="11">Subtraction</paragraph>
  90 </tablecell>
  91 <tablecell colspan="" rowspan="">
  92 <paragraph role="paragraph" id="par_id3150087" xml-lang="en-US" l10n="CHG" oldref="12">-</paragraph>
  93 </tablecell>
  94 <tablecell colspan="" rowspan="">
  95 <paragraph role="paragraph" id="par_id3153122" xml-lang="en-US" l10n="U" oldref="13">Calculates the difference</paragraph>
  96 <paragraph role="paragraph" id="par_id3153135" xml-lang="en-US" l10n="U" oldref="162">Example: 10 - &lt;B5&gt;</paragraph>
  97 </tablecell>
  98 </tablerow>
  99 <tablerow>
 100 <tablecell colspan="" rowspan="">
 101 <paragraph role="paragraph" id="par_id3149646" xml-lang="en-US" l10n="U" oldref="15">Multiplication</paragraph>
 102 </tablecell>
 103 <tablecell colspan="" rowspan="">
 104 <paragraph role="paragraph" id="par_id3154038" xml-lang="en-US" l10n="U" oldref="16">MUL or *</paragraph>
 105 </tablecell>
 106 <tablecell colspan="" rowspan="">
 107 <paragraph role="paragraph" id="par_id3149965" xml-lang="en-US" l10n="U" oldref="17">Calculates the product.</paragraph>
 108 <paragraph role="paragraph" id="par_id3149603" xml-lang="en-US" l10n="U" oldref="163">Example: 7 MUL 9</paragraph>
 109 </tablecell>
 110 </tablerow>
 111 <tablerow>
 112 <tablecell colspan="" rowspan="">
 113 <paragraph role="paragraph" id="par_id3145096" xml-lang="en-US" l10n="U" oldref="19">Division</paragraph>
 114 </tablecell>
 115 <tablecell colspan="" rowspan="">
 116 <paragraph role="paragraph" id="par_id3149570" xml-lang="en-US" l10n="U" oldref="20">DIV or /</paragraph>
 117 </tablecell>
 118 <tablecell colspan="" rowspan="">
 119 <paragraph role="paragraph" id="par_id3149592" xml-lang="en-US" l10n="U" oldref="21">Calculates the quotient</paragraph>
 120 <paragraph role="paragraph" id="par_id3156243" xml-lang="en-US" l10n="U" oldref="164">Example: 100 DIV 15</paragraph>
 121 </tablecell>
 122 </tablerow>
 123 </table>
 124 <paragraph role="heading" id="hd_id3156260" xml-lang="en-US" level="3" l10n="U" oldref="23">Basic Functions in the Submenu</paragraph>
 125 <table id="tbl_id3148926">
 126 <tablerow>
 127 <tablecell colspan="" rowspan="">
 128 <paragraph role="paragraph" id="par_id3145185" xml-lang="en-US" l10n="U" oldref="24">Sum</paragraph>
 129 </tablecell>
 130 <tablecell colspan="" rowspan="">
 131 <paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" l10n="U" oldref="25">SUM</paragraph>
 132 </tablecell>
 133 <tablecell colspan="" rowspan="">
 134 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_SUM" id="bm_id3154400" localize="false"/><paragraph role="paragraph" id="par_id3155335" xml-lang="en-US" l10n="U" oldref="26"><ahelp hid="HID_MN_CALC_SUM">Calculates the sum of the selected cells.</ahelp></paragraph>
 135 <paragraph role="paragraph" id="par_id3154411" xml-lang="en-US" l10n="U" oldref="165">Example: SUM &lt;A2:C2&gt; displays the sum of the values in cells A2 to C2</paragraph>
 136 </tablecell>
 137 </tablerow>
 138 <tablerow>
 139 <tablecell colspan="" rowspan="">
 140 <paragraph role="paragraph" id="par_id3153381" xml-lang="en-US" l10n="U" oldref="28">Round</paragraph>
 141 </tablecell>
 142 <tablecell colspan="" rowspan="">
 143 <paragraph role="paragraph" id="par_id3145598" xml-lang="en-US" l10n="U" oldref="29">ROUND</paragraph>
 144 </tablecell>
 145 <tablecell colspan="" rowspan="">
 146 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_ROUND" id="bm_id3154851" localize="false"/><paragraph role="paragraph" id="par_id3145621" xml-lang="en-US" l10n="U" oldref="30"><ahelp hid="HID_MN_CALC_ROUND">Rounds a number to the specified decimal places.</ahelp></paragraph>
 147 <paragraph role="paragraph" id="par_id3154862" xml-lang="en-US" l10n="U" oldref="166">Example: 15.678 ROUND 2 displays 15.68</paragraph>
 148 </tablecell>
 149 </tablerow>
 150 <tablerow>
 151 <tablecell colspan="" rowspan="">
 152 <paragraph role="paragraph" id="par_id3148687" xml-lang="en-US" l10n="U" oldref="32">Percent</paragraph>
 153 </tablecell>
 154 <tablecell colspan="" rowspan="">
 155 <paragraph role="paragraph" id="par_id3155930" xml-lang="en-US" l10n="U" oldref="33">PHD</paragraph>
 156 </tablecell>
 157 <tablecell colspan="" rowspan="">
 158 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_PHD" id="bm_id3149981" localize="false"/><paragraph role="paragraph" id="par_id3155953" xml-lang="en-US" l10n="U" oldref="34"><ahelp hid="HID_MN_CALC_PHD">Calculates a percentage</ahelp></paragraph>
 159 <paragraph role="paragraph" id="par_id3149991" xml-lang="en-US" l10n="U" oldref="167">Example: 10 + 15 PHD displays 10.15</paragraph>
 160 </tablecell>
 161 </tablerow>
 162 <tablerow>
 163 <tablecell colspan="" rowspan="">
 164 <paragraph role="paragraph" id="par_id3153016" xml-lang="en-US" l10n="U" oldref="36">Square Root</paragraph>
 165 </tablecell>
 166 <tablecell colspan="" rowspan="">
 167 <paragraph role="paragraph" id="par_id3153038" xml-lang="en-US" l10n="U" oldref="37">SQRT</paragraph>
 168 </tablecell>
 169 <tablecell colspan="" rowspan="">
 170 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_SQRT" id="bm_id3153074" localize="false"/><paragraph role="paragraph" id="par_id3153062" xml-lang="en-US" l10n="U" oldref="38"><ahelp hid="HID_MN_CALC_SQRT">Calculates the square root.</ahelp></paragraph>
 171 <paragraph role="paragraph" id="par_id3153882" xml-lang="en-US" l10n="U" oldref="168">Example: SQRT 25 displays 5.00</paragraph>
 172 </tablecell>
 173 </tablerow>
 174 <tablerow>
 175 <tablecell colspan="" rowspan="">
 176 <paragraph role="paragraph" id="par_id3153909" xml-lang="en-US" l10n="U" oldref="40">Power</paragraph>
 177 </tablecell>
 178 <tablecell colspan="" rowspan="">
 179 <paragraph role="paragraph" id="par_id3147124" xml-lang="en-US" l10n="U" oldref="41">POW</paragraph>
 180 </tablecell>
 181 <tablecell colspan="" rowspan="">
 182 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_POW" id="bm_id3149779" localize="false"/><paragraph role="paragraph" id="par_id3149768" xml-lang="en-US" l10n="U" oldref="42"><ahelp hid="HID_MN_CALC_POW">Calculates the power of a number.</ahelp></paragraph>
 183 <paragraph role="paragraph" id="par_id3149789" xml-lang="en-US" l10n="U" oldref="169">Example: 2 POW 8 displays 256.00</paragraph>
 184 </tablecell>
 185 </tablerow>
 186 </table>
 187 <bookmark xml-lang="en-US" branch="hid/HID_MN_POP_OPS" id="bm_id3150227" localize="false"/><paragraph role="heading" id="hd_id3150216" xml-lang="en-US" level="3" l10n="U" oldref="44">Operators</paragraph>
 188 <paragraph role="paragraph" id="par_id3150244" xml-lang="en-US" l10n="U" oldref="190"><ahelp hid="HID_MN_POP_OPS">You can insert various operators in your formula.</ahelp> Choose from the following functions:</paragraph>
 189 <table id="tbl_id3145218">
 190 <tablerow>
 191 <tablecell colspan="" rowspan="">
 192 <paragraph role="paragraph" id="par_id3150316" xml-lang="en-US" l10n="U" oldref="45">List Separator</paragraph>
 193 </tablecell>
 194 <tablecell colspan="" rowspan="">
 195 <paragraph role="paragraph" id="par_id3150339" xml-lang="en-US" l10n="U" oldref="46">|</paragraph>
 196 </tablecell>
 197 <tablecell colspan="" rowspan="">
 198 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_LISTSEP" id="bm_id3153110" localize="false"/><paragraph role="paragraph" id="par_id3153099" xml-lang="en-US" l10n="U" oldref="47"><ahelp hid="HID_MN_CALC_LISTSEP">Separates the elements in a list.</ahelp></paragraph>
 199 <paragraph role="paragraph" id="par_id3155817" xml-lang="en-US" l10n="U" oldref="170">Example of using a list:</paragraph>
 200 <paragraph role="paragraph" id="par_id3155830" xml-lang="en-US" l10n="U" oldref="212">MIN 10|20|50|&lt;C6&gt;|&lt;A2:B6&gt;|20</paragraph>
 201 </tablecell>
 202 </tablerow>
 203 <tablerow>
 204 <tablecell colspan="" rowspan="">
 205 <paragraph role="paragraph" id="par_id3147012" xml-lang="en-US" l10n="U" oldref="49">Equal</paragraph>
 206 </tablecell>
 207 <tablecell colspan="" rowspan="">
 208 <paragraph role="paragraph" id="par_id3147034" xml-lang="en-US" l10n="U" oldref="50">EQ or ==</paragraph>
 209 </tablecell>
 210 <tablecell colspan="" rowspan="">
 211 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_EQ" id="bm_id3150947" localize="false"/><paragraph role="paragraph" id="par_id3150936" xml-lang="en-US" l10n="U" oldref="51"><ahelp hid="HID_MN_CALC_EQ">Checks if selected values are equal.</ahelp> If they are unequal, the result is zero, otherwise 1 (true) appears.</paragraph>
 212 <paragraph role="paragraph" id="par_id3150961" xml-lang="en-US" l10n="U" oldref="171">Example: &lt;A1&gt; EQ 2 displays 1, if the content of A1 equals 2.</paragraph>
 213 </tablecell>
 214 </tablerow>
 215 <tablerow>
 216 <tablecell colspan="" rowspan="">
 217 <paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="U" oldref="53">Not Equal</paragraph>
 218 </tablecell>
 219 <tablecell colspan="" rowspan="">
 220 <paragraph role="paragraph" id="par_id3150503" xml-lang="en-US" l10n="U" oldref="54">NEQ or !=</paragraph>
 221 </tablecell>
 222 <tablecell colspan="" rowspan="">
 223 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_NEQ" id="bm_id3150537" localize="false"/><paragraph role="paragraph" id="par_id3150526" xml-lang="en-US" l10n="U" oldref="55"><ahelp hid="HID_MN_CALC_NEQ">Tests for inequality between selected values.</ahelp></paragraph>
 224 <paragraph role="paragraph" id="par_id3147524" xml-lang="en-US" l10n="U" oldref="172">Example: &lt;A1&gt; NEQ 2 displays 0 (wrong), if the content of A1 equals 2.</paragraph>
 225 </tablecell>
 226 </tablerow>
 227 <tablerow>
 228 <tablecell colspan="" rowspan="">
 229 <paragraph role="paragraph" id="par_id3147553" xml-lang="en-US" l10n="U" oldref="57">Less than or Equal</paragraph>
 230 </tablecell>
 231 <tablecell colspan="" rowspan="">
 232 <paragraph role="paragraph" id="par_id3153599" xml-lang="en-US" l10n="U" oldref="58">LEQ</paragraph>
 233 </tablecell>
 234 <tablecell colspan="" rowspan="">
 235 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_LEQ" id="bm_id3151268" localize="false"/><paragraph role="paragraph" id="par_id3153622" xml-lang="en-US" l10n="U" oldref="59"><ahelp hid="HID_MN_CALC_LEQ">Tests for values less than or equal to a specified value.</ahelp></paragraph>
 236 <paragraph role="paragraph" id="par_id3151280" xml-lang="en-US" l10n="U" oldref="173">Example: &lt;A1&gt; LEQ 2 displays 1 (true), if the content of A1 is less than or equal to 2.</paragraph>
 237 </tablecell>
 238 </tablerow>
 239 <tablerow>
 240 <tablecell colspan="" rowspan="">
 241 <paragraph role="paragraph" id="par_id3153729" xml-lang="en-US" l10n="U" oldref="61">Greater than or Equal</paragraph>
 242 </tablecell>
 243 <tablecell colspan="" rowspan="">
 244 <paragraph role="paragraph" id="par_id3153751" xml-lang="en-US" l10n="U" oldref="62">GEQ</paragraph>
 245 </tablecell>
 246 <tablecell colspan="" rowspan="">
 247 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_GEQ" id="bm_id3148887" localize="false"/><paragraph role="paragraph" id="par_id3148876" xml-lang="en-US" l10n="U" oldref="63"><ahelp hid="HID_MN_CALC_GEQ">Tests for values greater than or equal to a specified value</ahelp></paragraph>
 248 <paragraph role="paragraph" id="par_id3148898" xml-lang="en-US" l10n="U" oldref="174">Example: &lt;A1&gt; GEQ 2 displays 1 (true), if the content of A1 is greater than or equal to 2.</paragraph>
 249 </tablecell>
 250 </tablerow>
 251 <tablerow>
 252 <tablecell colspan="" rowspan="">
 253 <paragraph role="paragraph" id="par_id3150836" xml-lang="en-US" l10n="U" oldref="65">Less</paragraph>
 254 </tablecell>
 255 <tablecell colspan="" rowspan="">
 256 <paragraph role="paragraph" id="par_id3150859" xml-lang="en-US" l10n="U" oldref="66">L</paragraph>
 257 </tablecell>
 258 <tablecell colspan="" rowspan="">
 259 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_LES" id="bm_id3155422" localize="false"/><paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U" oldref="67"><ahelp hid="HID_MN_CALC_LES">Tests for values less than a specified value</ahelp></paragraph>
 260 <paragraph role="paragraph" id="par_id3155433" xml-lang="en-US" l10n="U" oldref="175">Example: &lt;A1&gt; L 2 displays 1 (true), if the content of A1 is less than 2.</paragraph>
 261 </tablecell>
 262 </tablerow>
 263 <tablerow>
 264 <tablecell colspan="" rowspan="">
 265 <paragraph role="paragraph" id="par_id3150720" xml-lang="en-US" l10n="U" oldref="69">Greater</paragraph>
 266 </tablecell>
 267 <tablecell colspan="" rowspan="">
 268 <paragraph role="paragraph" id="par_id3150743" xml-lang="en-US" l10n="U" oldref="70">G</paragraph>
 269 </tablecell>
 270 <tablecell colspan="" rowspan="">
 271 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_GRE" id="bm_id3147322" localize="false"/><paragraph role="paragraph" id="par_id3147310" xml-lang="en-US" l10n="U" oldref="71"><ahelp hid="HID_MN_CALC_GRE">Tests for values greater than a specified value</ahelp></paragraph>
 272 <paragraph role="paragraph" id="par_id3147333" xml-lang="en-US" l10n="U" oldref="176">Example: &lt;A1&gt; G 2 displays 1 (true), if the content of A1 is greater than 2.</paragraph>
 273 </tablecell>
 274 </tablerow>
 275 <tablerow>
 276 <tablecell colspan="" rowspan="">
 277 <paragraph role="paragraph" id="par_id3148408" xml-lang="en-US" l10n="U" oldref="73">Boolean Or</paragraph>
 278 </tablecell>
 279 <tablecell colspan="" rowspan="">
 280 <paragraph role="paragraph" id="par_id3148430" xml-lang="en-US" l10n="U" oldref="74">OR</paragraph>
 281 </tablecell>
 282 <tablecell colspan="" rowspan="">
 283 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_OR" id="bm_id3150286" localize="false"/><paragraph role="paragraph" id="par_id3150274" xml-lang="en-US" l10n="U" oldref="75"><ahelp hid="HID_MN_CALC_OR">Tests for values matching the Boolean OR</ahelp></paragraph>
 284 <paragraph role="paragraph" id="par_id3150297" xml-lang="en-US" l10n="U" oldref="181">Example: 0 OR 0 displays 0 (false), anything else results in 1 (true)</paragraph>
 285 </tablecell>
 286 </tablerow>
 287 <tablerow>
 288 <tablecell colspan="" rowspan="">
 289 <paragraph role="paragraph" id="par_id3149434" xml-lang="en-US" l10n="U" oldref="76">Boolean X Or</paragraph>
 290 </tablecell>
 291 <tablecell colspan="" rowspan="">
 292 <paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" l10n="U" oldref="77">XOR</paragraph>
 293 </tablecell>
 294 <tablecell colspan="" rowspan="">
 295 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_XOR" id="bm_id3146992" localize="false"/><paragraph role="paragraph" id="par_id3146980" xml-lang="en-US" l10n="U" oldref="78"><ahelp hid="HID_MN_CALC_XOR">Tests for values matching the Boolean exclusive OR</ahelp></paragraph>
 296 <paragraph role="paragraph" id="par_id3147003" xml-lang="en-US" l10n="U" oldref="182">Example: 1 XOR 0 displays 1 (true)</paragraph>
 297 </tablecell>
 298 </tablerow>
 299 <tablerow>
 300 <tablecell colspan="" rowspan="">
 301 <paragraph role="paragraph" id="par_id3152925" xml-lang="en-US" l10n="U" oldref="79">Boolean And</paragraph>
 302 </tablecell>
 303 <tablecell colspan="" rowspan="">
 304 <paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" l10n="U" oldref="80">AND</paragraph>
 305 </tablecell>
 306 <tablecell colspan="" rowspan="">
 307 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_AND" id="bm_id3153803" localize="false"/><paragraph role="paragraph" id="par_id3153792" xml-lang="en-US" l10n="U" oldref="81"><ahelp hid="HID_MN_CALC_AND">Tests for values matching the Boolean AND</ahelp></paragraph>
 308 <paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U" oldref="183">Example: 1 AND 2 displays 1 (true)</paragraph>
 309 </tablecell>
 310 </tablerow>
 311 <tablerow>
 312 <tablecell colspan="" rowspan="">
 313 <paragraph role="paragraph" id="par_id3153938" xml-lang="en-US" l10n="U" oldref="82">Boolean Not</paragraph>
 314 </tablecell>
 315 <tablecell colspan="" rowspan="">
 316 <paragraph role="paragraph" id="par_id3153961" xml-lang="en-US" l10n="U" oldref="83">NOT</paragraph>
 317 </tablecell>
 318 <tablecell colspan="" rowspan="">
 319 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_NOT" id="bm_id3148644" localize="false"/><paragraph role="paragraph" id="par_id3148633" xml-lang="en-US" l10n="U" oldref="84"><ahelp hid="HID_MN_CALC_NOT">Tests for values matching the Boolean NOT</ahelp></paragraph>
 320 <paragraph role="paragraph" id="par_id3148655" xml-lang="en-US" l10n="U" oldref="184">Example: NOT 1 (true) displays 0 (false)</paragraph>
 321 </tablecell>
 322 </tablerow>
 323 </table>
 324 <bookmark xml-lang="en-US" branch="hid/HID_MN_POP_STATISTICS" id="bm_id3154251" localize="false"/><paragraph role="heading" id="hd_id3154240" xml-lang="en-US" level="3" l10n="U" oldref="85">Statistical Functions</paragraph>
 325 <paragraph role="paragraph" id="par_id3154263" xml-lang="en-US" l10n="U" oldref="191"><ahelp hid="HID_MN_POP_STATISTICS">You can choose from the following statistical functions:</ahelp></paragraph>
 326 <table id="tbl_id3154282">
 327 <tablerow>
 328 <tablecell colspan="" rowspan="">
 329 <paragraph role="paragraph" id="par_id3153176" xml-lang="en-US" l10n="U" oldref="86">Mean</paragraph>
 330 </tablecell>
 331 <tablecell colspan="" rowspan="">
 332 <paragraph role="paragraph" id="par_id3154053" xml-lang="en-US" l10n="U" oldref="87">MEAN</paragraph>
 333 </tablecell>
 334 <tablecell colspan="" rowspan="">
 335 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_MEAN" id="bm_id3154087" localize="false"/><paragraph role="paragraph" id="par_id3154076" xml-lang="en-US" l10n="U" oldref="88"><ahelp hid="HID_MN_CALC_MEAN">Calculates the arithmetic mean of the values in an area or a list.</ahelp></paragraph>
 336 <paragraph role="paragraph" id="par_id3145625" xml-lang="en-US" l10n="U" oldref="177">Example: MEAN 10|30|20 displays 20</paragraph>
 337 </tablecell>
 338 </tablerow>
 339 <tablerow>
 340 <tablecell colspan="" rowspan="">
 341 <paragraph role="paragraph" id="par_id3145652" xml-lang="en-US" l10n="U" oldref="90">Minimum Value</paragraph>
 342 </tablecell>
 343 <tablecell colspan="" rowspan="">
 344 <paragraph role="paragraph" id="par_id3155258" xml-lang="en-US" l10n="U" oldref="91">MIN</paragraph>
 345 </tablecell>
 346 <tablecell colspan="" rowspan="">
 347 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_MIN" id="bm_id3155292" localize="false"/><paragraph role="paragraph" id="par_id3155281" xml-lang="en-US" l10n="U" oldref="92"><ahelp hid="HID_MN_CALC_MIN">Calculates the minimum value in an area or a list.</ahelp></paragraph>
 348 <paragraph role="paragraph" id="par_id3155304" xml-lang="en-US" l10n="U" oldref="178">Example: MIN 10|30|20 displays 10</paragraph>
 349 </tablecell>
 350 </tablerow>
 351 <tablerow>
 352 <tablecell colspan="" rowspan="">
 353 <paragraph role="paragraph" id="par_id3153993" xml-lang="en-US" l10n="U" oldref="94">Maximum Value</paragraph>
 354 </tablecell>
 355 <tablecell colspan="" rowspan="">
 356 <paragraph role="paragraph" id="par_id3154016" xml-lang="en-US" l10n="U" oldref="95">MAX</paragraph>
 357 </tablecell>
 358 <tablecell colspan="" rowspan="">
 359 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_MAX" id="bm_id3154737" localize="false"/><paragraph role="paragraph" id="par_id3154726" xml-lang="en-US" l10n="U" oldref="96"><ahelp hid="HID_MN_CALC_MAX">Calculates the maximum value in an area or a list.</ahelp></paragraph>
 360 <paragraph role="paragraph" id="par_id3154748" xml-lang="en-US" l10n="U" oldref="179">Example: MAX 10|30|20 displays 30.00</paragraph>
 361 </tablecell>
 362 </tablerow>
 363 </table>
 364 <bookmark xml-lang="en-US" branch="hid/HID_MN_POP_FUNC" id="bm_id3153211" localize="false"/><paragraph role="heading" id="hd_id3153200" xml-lang="en-US" level="3" l10n="U" oldref="98">Trigonometric Functions </paragraph>
 365 <paragraph role="paragraph" id="par_id3153226" xml-lang="en-US" l10n="U" oldref="192"><ahelp hid="HID_MN_POP_FUNC">You can choose from the following trigonometric functions:</ahelp></paragraph>
 366 <table id="tbl_id3145120">
 367 <tablerow>
 368 <tablecell colspan="" rowspan="">
 369 <paragraph role="paragraph" id="par_id3145156" xml-lang="en-US" l10n="U" oldref="99">Sine</paragraph>
 370 </tablecell>
 371 <tablecell colspan="" rowspan="">
 372 <paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" l10n="U" oldref="100">SIN</paragraph>
 373 </tablecell>
 374 <tablecell colspan="" rowspan="">
 375 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_SIN" id="bm_id3149541" localize="false"/><paragraph role="paragraph" id="par_id3149530" xml-lang="en-US" l10n="U" oldref="101"><ahelp hid="HID_MN_CALC_SIN">Calculates the sine in radians</ahelp></paragraph>
 376 <paragraph role="paragraph" id="par_id3153312" xml-lang="en-US" l10n="U" oldref="180">Example: SIN (PI/2)</paragraph>
 377 </tablecell>
 378 </tablerow>
 379 <tablerow>
 380 <tablecell colspan="" rowspan="">
 381 <paragraph role="paragraph" id="par_id3153340" xml-lang="en-US" l10n="U" oldref="103">Cosine</paragraph>
 382 </tablecell>
 383 <tablecell colspan="" rowspan="">
 384 <paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" l10n="U" oldref="104">COS</paragraph>
 385 </tablecell>
 386 <tablecell colspan="" rowspan="">
 387 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_COS" id="bm_id3154544" localize="false"/><paragraph role="paragraph" id="par_id3154533" xml-lang="en-US" l10n="U" oldref="105"><ahelp hid="HID_MN_CALC_COS">Calculates the cosine in radians.</ahelp></paragraph>
 388 <paragraph role="paragraph" id="par_id3154554" xml-lang="en-US" l10n="U" oldref="185">Example: COS 1</paragraph>
 389 </tablecell>
 390 </tablerow>
 391 <tablerow>
 392 <tablecell colspan="" rowspan="">
 393 <paragraph role="paragraph" id="par_id3150989" xml-lang="en-US" l10n="U" oldref="106">Tangent</paragraph>
 394 </tablecell>
 395 <tablecell colspan="" rowspan="">
 396 <paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" l10n="U" oldref="107">TAN</paragraph>
 397 </tablecell>
 398 <tablecell colspan="" rowspan="">
 399 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_TAN" id="bm_id3149380" localize="false"/><paragraph role="paragraph" id="par_id3149369" xml-lang="en-US" l10n="U" oldref="108"><ahelp hid="HID_MN_CALC_TAN">Calculates the tangent in radians.</ahelp></paragraph>
 400 <paragraph role="paragraph" id="par_id3149391" xml-lang="en-US" l10n="U" oldref="186">Example: TAN &lt;A1&gt;</paragraph>
 401 </tablecell>
 402 </tablerow>
 403 <tablerow>
 404 <tablecell colspan="" rowspan="">
 405 <paragraph role="paragraph" id="par_id3151032" xml-lang="en-US" l10n="U" oldref="109">Arc Sine</paragraph>
 406 </tablecell>
 407 <tablecell colspan="" rowspan="">
 408 <paragraph role="paragraph" id="par_id3151055" xml-lang="en-US" l10n="U" oldref="110">ASIN</paragraph>
 409 </tablecell>
 410 <tablecell colspan="" rowspan="">
 411 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_ASIN" id="bm_id3150577" localize="false"/><paragraph role="paragraph" id="par_id3150565" xml-lang="en-US" l10n="U" oldref="111"><ahelp hid="HID_MN_CALC_ASIN">Calculates the arc sine in radians.</ahelp></paragraph>
 412 <paragraph role="paragraph" id="par_id3150588" xml-lang="en-US" l10n="U" oldref="187">Example: ASIN 1</paragraph>
 413 </tablecell>
 414 </tablerow>
 415 <tablerow>
 416 <tablecell colspan="" rowspan="">
 417 <paragraph role="paragraph" id="par_id3150615" xml-lang="en-US" l10n="U" oldref="112">Arc Cosine</paragraph>
 418 </tablecell>
 419 <tablecell colspan="" rowspan="">
 420 <paragraph role="paragraph" id="par_id3149728" xml-lang="en-US" l10n="U" oldref="113">ACOS</paragraph>
 421 </tablecell>
 422 <tablecell colspan="" rowspan="">
 423 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_ACOS" id="bm_id3153822" localize="false"/><paragraph role="paragraph" id="par_id3149750" xml-lang="en-US" l10n="U" oldref="114"><ahelp hid="HID_MN_CALC_ACOS">Calculates the arc cosine in radians.</ahelp></paragraph>
 424 <paragraph role="paragraph" id="par_id3153833" xml-lang="en-US" l10n="U" oldref="188">Example: ACOS 1</paragraph>
 425 </tablecell>
 426 </tablerow>
 427 <tablerow>
 428 <tablecell colspan="" rowspan="">
 429 <paragraph role="paragraph" id="par_id3153860" xml-lang="en-US" l10n="U" oldref="115">Arc Tangent</paragraph>
 430 </tablecell>
 431 <tablecell colspan="" rowspan="">
 432 <paragraph role="paragraph" id="par_id3147057" xml-lang="en-US" l10n="U" oldref="116">ATAN</paragraph>
 433 </tablecell>
 434 <tablecell colspan="" rowspan="">
 435 <bookmark xml-lang="en-US" branch="hid/HID_MN_CALC_ATAN" id="bm_id3147091" localize="false"/><paragraph role="paragraph" id="par_id3147080" xml-lang="en-US" l10n="U" oldref="117"><ahelp hid="HID_MN_CALC_ATAN">Calculates the arc tangent in radians.</ahelp></paragraph>
 436 <paragraph role="paragraph" id="par_id3147102" xml-lang="en-US" l10n="U" oldref="189">Example: ATAN 1</paragraph>
 437 </tablecell>
 438 </tablerow>
 439 </table>
 440 <paragraph role="heading" id="hd_id3150888" xml-lang="en-US" level="3" l10n="U" oldref="194">Variables for document properties</paragraph>
 441 <paragraph role="paragraph" id="par_id3150161" xml-lang="en-US" l10n="U" oldref="210">The following document properties are also found under <emph>File - Properties - Statistics</emph>.</paragraph>
 442 <table id="tbl_id3157507">
 443 <tablerow>
 444 <tablecell colspan="" rowspan="">
 445 <paragraph role="paragraph" id="par_id3157538" xml-lang="en-US" l10n="U" oldref="195">CHAR</paragraph>
 446 </tablecell>
 447 <tablecell colspan="" rowspan="">
 448 <paragraph role="paragraph" id="par_id3152954" xml-lang="en-US" l10n="U" oldref="196">Number of characters in the document</paragraph>
 449 </tablecell>
 450 </tablerow>
 451 <tablerow>
 452 <tablecell colspan="" rowspan="">
 453 <paragraph role="paragraph" id="par_id3152982" xml-lang="en-US" l10n="U" oldref="197">WORD</paragraph>
 454 </tablecell>
 455 <tablecell colspan="" rowspan="">
 456 <paragraph role="paragraph" id="par_id3153005" xml-lang="en-US" l10n="U" oldref="198">Number of words in the document</paragraph>
 457 </tablecell>
 458 </tablerow>
 459 <tablerow>
 460 <tablecell colspan="" rowspan="">
 461 <paragraph role="paragraph" id="par_id3152715" xml-lang="en-US" l10n="U" oldref="199">PARA</paragraph>
 462 </tablecell>
 463 <tablecell colspan="" rowspan="">
 464 <paragraph role="paragraph" id="par_id3152738" xml-lang="en-US" l10n="U" oldref="200">Number of paragraphs in the document</paragraph>
 465 </tablecell>
 466 </tablerow>
 467 <tablerow>
 468 <tablecell colspan="" rowspan="">
 469 <paragraph role="paragraph" id="par_id3148453" xml-lang="en-US" l10n="U" oldref="201">GRAPH</paragraph>
 470 </tablecell>
 471 <tablecell colspan="" rowspan="">
 472 <paragraph role="paragraph" id="par_id3148476" xml-lang="en-US" l10n="U" oldref="202">Number of graphics in the document</paragraph>
 473 </tablecell>
 474 </tablerow>
 475 <tablerow>
 476 <tablecell colspan="" rowspan="">
 477 <paragraph role="paragraph" id="par_id3151091" xml-lang="en-US" l10n="U" oldref="203">TABLES</paragraph>
 478 </tablecell>
 479 <tablecell colspan="" rowspan="">
 480 <paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="204">Number of tables in the document</paragraph>
 481 </tablecell>
 482 </tablerow>
 483 <tablerow>
 484 <tablecell colspan="" rowspan="">
 485 <paragraph role="paragraph" id="par_id3151198" xml-lang="en-US" l10n="U" oldref="205">OLE</paragraph>
 486 </tablecell>
 487 <tablecell colspan="" rowspan="">
 488 <paragraph role="paragraph" id="par_id3151220" xml-lang="en-US" l10n="U" oldref="206">Number of OLE objects in the document</paragraph>
 489 </tablecell>
 490 </tablerow>
 491 <tablerow>
 492 <tablecell colspan="" rowspan="">
 493 <paragraph role="paragraph" id="par_id3146903" xml-lang="en-US" l10n="U" oldref="207">PAGE</paragraph>
 494 </tablecell>
 495 <tablecell colspan="" rowspan="">
 496 <paragraph role="paragraph" id="par_id3146926" xml-lang="en-US" l10n="U" oldref="208">Total number of pages in the document</paragraph>
 497 </tablecell>
 498 </tablerow>
 499 </table>
 500 <paragraph role="heading" id="hd_id3146944" xml-lang="en-US" level="3" l10n="U" oldref="127">More Defined Values</paragraph>
 501 <table id="tbl_id3146957">
 502 <tablerow>
 503 <tablecell colspan="" rowspan="">
 504 <paragraph role="paragraph" id="par_id3153562" xml-lang="en-US" l10n="U" oldref="128">PI</paragraph>
 505 </tablecell>
 506 <tablecell colspan="" rowspan="">
 507 <paragraph role="paragraph" id="par_id3147343" xml-lang="en-US" l10n="U" oldref="129">PI</paragraph>
 508 </tablecell>
 509 <tablecell colspan="" rowspan="">
 510 <paragraph role="paragraph" id="par_id3147366" xml-lang="en-US" l10n="U" oldref="130">3.1415...</paragraph>
 511 </tablecell>
 512 </tablerow>
 513 <tablerow>
 514 <tablecell colspan="" rowspan="">
 515 <paragraph role="paragraph" id="par_id3147393" xml-lang="en-US" l10n="U" oldref="131">Euler's constant</paragraph>
 516 </tablecell>
 517 <tablecell colspan="" rowspan="">
 518 <paragraph role="paragraph" id="par_id3147462" xml-lang="en-US" l10n="U" oldref="132">E</paragraph>
 519 </tablecell>
 520 <tablecell colspan="" rowspan="">
 521 <paragraph role="paragraph" id="par_id3147485" xml-lang="en-US" l10n="CHG" oldref="133">2.71828...</paragraph>
 522 </tablecell>
 523 </tablerow>
 524 <tablerow>
 525 <tablecell colspan="" rowspan="">
 526 <paragraph role="paragraph" id="par_id3145332" xml-lang="en-US" l10n="U" oldref="134">True</paragraph>
 527 </tablecell>
 528 <tablecell colspan="" rowspan="">
 529 <paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="135">TRUE</paragraph>
 530 </tablecell>
 531 <tablecell colspan="" rowspan="">
 532 <paragraph role="paragraph" id="par_id3145378" xml-lang="en-US" l10n="U" oldref="136">not equal to 0</paragraph>
 533 </tablecell>
 534 </tablerow>
 535 <tablerow>
 536 <tablecell colspan="" rowspan="">
 537 <paragraph role="paragraph" id="par_id3150362" xml-lang="en-US" l10n="U" oldref="137">False</paragraph>
 538 </tablecell>
 539 <tablecell colspan="" rowspan="">
 540 <paragraph role="paragraph" id="par_id3150385" xml-lang="en-US" l10n="U" oldref="138">FALSE</paragraph>
 541 </tablecell>
 542 <tablecell colspan="" rowspan="">
 543 <paragraph role="paragraph" id="par_id3149304" xml-lang="en-US" l10n="U" oldref="139">0</paragraph>
 544 </tablecell>
 545 </tablerow>
 546 </table>
 547 </body>
 548 </helpdocument>