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 2000, 2010 Oracle and/or its affiliates. 11 * 12 * OpenOffice.org - a multi-platform office productivity suite 13 * 14 * This file is part of OpenOffice.org. 15 * 16 * OpenOffice.org is free software: you can redistribute it and/or modify 17 * it under the terms of the GNU Lesser General Public License version 3 18 * only, as published by the Free Software Foundation. 19 * 20 * OpenOffice.org is distributed in the hope that it will be useful, 21 * but WITHOUT ANY WARRANTY; without even the implied warranty of 22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23 * GNU Lesser General Public License version 3 for more details 24 * (a copy is included in the LICENSE file that accompanied this code). 25 * 26 * You should have received a copy of the GNU Lesser General Public License 27 * version 3 along with OpenOffice.org. If not, see 28 * <http://www.openoffice.org/license.html> 29 * for a copy of the LGPLv3 License. 30 * 31 ************************************************************************ 32 --> 33 34 35 <helpdocument version="1.0"> 36<meta> 37<topic id="textswriter0214020000xml" indexer="include" status="PUBLISH"> 38<title id="tit" xml-lang="en-US">Formula</title> 39<filename>/text/swriter/02/14020000.xhp</filename> 40</topic> 41</meta> 42<body> 43<section id="formel"> 44<bookmark xml-lang="en-US" branch="index" id="bm_id3149687"><bookmark_value>operators; in formulas</bookmark_value> 45<bookmark_value>statistical functions</bookmark_value> 46<bookmark_value>trigonometric functions</bookmark_value> 47<bookmark_value>pages;number of</bookmark_value> 48<bookmark_value>variables;document properties</bookmark_value> 49<bookmark_value>arithmetical operators in formulas</bookmark_value> 50</bookmark> 51<bookmark xml-lang="en-US" branch="hid/SW_HID_TBX_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> 52<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> 53</section> 54<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> 55<section id="syformel"> 56<table id="tbl_id3153634"> 57<tablerow> 58<tablecell colspan="" rowspan=""> 59<paragraph role="paragraph" id="par_id3155142" xml-lang="en-US" l10n="E"> 60<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> 61 </image></paragraph> 62</tablecell> 63<tablecell colspan="" rowspan=""> 64<paragraph role="paragraph" id="par_id3150113" xml-lang="en-US" l10n="U" oldref="4">Formula</paragraph> 65</tablecell> 66</tablerow> 67</table> 68</section> 69<paragraph role="heading" id="hd_id3150691" xml-lang="en-US" level="2" l10n="U" oldref="5">Summary of Formula Options</paragraph> 70<paragraph role="heading" id="hd_id3155858" xml-lang="en-US" level="3" l10n="U" oldref="6">Basic Calculation Functions</paragraph> 71<table id="tbl_id3155870"> 72<tablerow> 73<tablecell colspan="" rowspan=""> 74<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="7">Addition</paragraph> 75</tablecell> 76<tablecell colspan="" rowspan=""> 77<paragraph role="paragraph" id="par_id3150563" xml-lang="en-US" l10n="U" oldref="8">+</paragraph> 78</tablecell> 79<tablecell colspan="" rowspan=""> 80<paragraph role="paragraph" id="par_id3149831" xml-lang="en-US" l10n="U" oldref="9">Calculates the total.</paragraph> 81<paragraph role="paragraph" id="par_id3149845" xml-lang="en-US" l10n="U" oldref="161">Example: <A1> + 8</paragraph> 82</tablecell> 83</tablerow> 84<tablerow> 85<tablecell colspan="" rowspan=""> 86<paragraph role="paragraph" id="par_id3156097" xml-lang="en-US" l10n="U" oldref="11">Subtraction</paragraph> 87</tablecell> 88<tablecell colspan="" rowspan=""> 89<paragraph role="paragraph" id="par_id3150087" xml-lang="en-US" l10n="CHG" oldref="12">-</paragraph> 90</tablecell> 91<tablecell colspan="" rowspan=""> 92<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US" l10n="U" oldref="13">Calculates the difference</paragraph> 93<paragraph role="paragraph" id="par_id3153135" xml-lang="en-US" l10n="U" oldref="162">Example: 10 - <B5></paragraph> 94</tablecell> 95</tablerow> 96<tablerow> 97<tablecell colspan="" rowspan=""> 98<paragraph role="paragraph" id="par_id3149646" xml-lang="en-US" l10n="U" oldref="15">Multiplication</paragraph> 99</tablecell> 100<tablecell colspan="" rowspan=""> 101<paragraph role="paragraph" id="par_id3154038" xml-lang="en-US" l10n="U" oldref="16">MUL or *</paragraph> 102</tablecell> 103<tablecell colspan="" rowspan=""> 104<paragraph role="paragraph" id="par_id3149965" xml-lang="en-US" l10n="U" oldref="17">Calculates the product.</paragraph> 105<paragraph role="paragraph" id="par_id3149603" xml-lang="en-US" l10n="U" oldref="163">Example: 7 MUL 9</paragraph> 106</tablecell> 107</tablerow> 108<tablerow> 109<tablecell colspan="" rowspan=""> 110<paragraph role="paragraph" id="par_id3145096" xml-lang="en-US" l10n="U" oldref="19">Division</paragraph> 111</tablecell> 112<tablecell colspan="" rowspan=""> 113<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US" l10n="U" oldref="20">DIV or /</paragraph> 114</tablecell> 115<tablecell colspan="" rowspan=""> 116<paragraph role="paragraph" id="par_id3149592" xml-lang="en-US" l10n="U" oldref="21">Calculates the quotient</paragraph> 117<paragraph role="paragraph" id="par_id3156243" xml-lang="en-US" l10n="U" oldref="164">Example: 100 DIV 15</paragraph> 118</tablecell> 119</tablerow> 120</table> 121<paragraph role="heading" id="hd_id3156260" xml-lang="en-US" level="3" l10n="U" oldref="23">Basic Functions in the Submenu</paragraph> 122<table id="tbl_id3148926"> 123<tablerow> 124<tablecell colspan="" rowspan=""> 125<paragraph role="paragraph" id="par_id3145185" xml-lang="en-US" l10n="U" oldref="24">Sum</paragraph> 126</tablecell> 127<tablecell colspan="" rowspan=""> 128<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" l10n="U" oldref="25">SUM</paragraph> 129</tablecell> 130<tablecell colspan="" rowspan=""> 131<bookmark xml-lang="en-US" branch="hid/SW_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> 132<paragraph role="paragraph" id="par_id3154411" xml-lang="en-US" l10n="U" oldref="165">Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2</paragraph> 133</tablecell> 134</tablerow> 135<tablerow> 136<tablecell colspan="" rowspan=""> 137<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US" l10n="U" oldref="28">Round</paragraph> 138</tablecell> 139<tablecell colspan="" rowspan=""> 140<paragraph role="paragraph" id="par_id3145598" xml-lang="en-US" l10n="U" oldref="29">ROUND</paragraph> 141</tablecell> 142<tablecell colspan="" rowspan=""> 143<bookmark xml-lang="en-US" branch="hid/SW_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> 144<paragraph role="paragraph" id="par_id3154862" xml-lang="en-US" l10n="U" oldref="166">Example: 15.678 ROUND 2 displays 15.68</paragraph> 145</tablecell> 146</tablerow> 147<tablerow> 148<tablecell colspan="" rowspan=""> 149<paragraph role="paragraph" id="par_id3148687" xml-lang="en-US" l10n="U" oldref="32">Percent</paragraph> 150</tablecell> 151<tablecell colspan="" rowspan=""> 152<paragraph role="paragraph" id="par_id3155930" xml-lang="en-US" l10n="U" oldref="33">PHD</paragraph> 153</tablecell> 154<tablecell colspan="" rowspan=""> 155<bookmark xml-lang="en-US" branch="hid/SW_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> 156<paragraph role="paragraph" id="par_id3149991" xml-lang="en-US" l10n="U" oldref="167">Example: 10 + 15 PHD displays 10.15</paragraph> 157</tablecell> 158</tablerow> 159<tablerow> 160<tablecell colspan="" rowspan=""> 161<paragraph role="paragraph" id="par_id3153016" xml-lang="en-US" l10n="U" oldref="36">Square Root</paragraph> 162</tablecell> 163<tablecell colspan="" rowspan=""> 164<paragraph role="paragraph" id="par_id3153038" xml-lang="en-US" l10n="U" oldref="37">SQRT</paragraph> 165</tablecell> 166<tablecell colspan="" rowspan=""> 167<bookmark xml-lang="en-US" branch="hid/SW_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> 168<paragraph role="paragraph" id="par_id3153882" xml-lang="en-US" l10n="U" oldref="168">Example: SQRT 25 displays 5.00</paragraph> 169</tablecell> 170</tablerow> 171<tablerow> 172<tablecell colspan="" rowspan=""> 173<paragraph role="paragraph" id="par_id3153909" xml-lang="en-US" l10n="U" oldref="40">Power</paragraph> 174</tablecell> 175<tablecell colspan="" rowspan=""> 176<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US" l10n="U" oldref="41">POW</paragraph> 177</tablecell> 178<tablecell colspan="" rowspan=""> 179<bookmark xml-lang="en-US" branch="hid/SW_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> 180<paragraph role="paragraph" id="par_id3149789" xml-lang="en-US" l10n="U" oldref="169">Example: 2 POW 8 displays 256.00</paragraph> 181</tablecell> 182</tablerow> 183</table> 184<bookmark xml-lang="en-US" branch="hid/SW_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> 185<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> 186<table id="tbl_id3145218"> 187<tablerow> 188<tablecell colspan="" rowspan=""> 189<paragraph role="paragraph" id="par_id3150316" xml-lang="en-US" l10n="U" oldref="45">List Separator</paragraph> 190</tablecell> 191<tablecell colspan="" rowspan=""> 192<paragraph role="paragraph" id="par_id3150339" xml-lang="en-US" l10n="U" oldref="46">|</paragraph> 193</tablecell> 194<tablecell colspan="" rowspan=""> 195<bookmark xml-lang="en-US" branch="hid/SW_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> 196<paragraph role="paragraph" id="par_id3155817" xml-lang="en-US" l10n="U" oldref="170">Example of using a list:</paragraph> 197<paragraph role="paragraph" id="par_id3155830" xml-lang="en-US" l10n="U" oldref="212">MIN 10|20|50|<C6>|<A2:B6>|20</paragraph> 198</tablecell> 199</tablerow> 200<tablerow> 201<tablecell colspan="" rowspan=""> 202<paragraph role="paragraph" id="par_id3147012" xml-lang="en-US" l10n="U" oldref="49">Equal</paragraph> 203</tablecell> 204<tablecell colspan="" rowspan=""> 205<paragraph role="paragraph" id="par_id3147034" xml-lang="en-US" l10n="U" oldref="50">EQ or ==</paragraph> 206</tablecell> 207<tablecell colspan="" rowspan=""> 208<bookmark xml-lang="en-US" branch="hid/SW_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> 209<paragraph role="paragraph" id="par_id3150961" xml-lang="en-US" l10n="U" oldref="171">Example: <A1> EQ 2 displays 1, if the content of A1 equals 2.</paragraph> 210</tablecell> 211</tablerow> 212<tablerow> 213<tablecell colspan="" rowspan=""> 214<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="U" oldref="53">Not Equal</paragraph> 215</tablecell> 216<tablecell colspan="" rowspan=""> 217<paragraph role="paragraph" id="par_id3150503" xml-lang="en-US" l10n="U" oldref="54">NEQ or !=</paragraph> 218</tablecell> 219<tablecell colspan="" rowspan=""> 220<bookmark xml-lang="en-US" branch="hid/SW_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> 221<paragraph role="paragraph" id="par_id3147524" xml-lang="en-US" l10n="U" oldref="172">Example: <A1> NEQ 2 displays 0 (wrong), if the content of A1 equals 2.</paragraph> 222</tablecell> 223</tablerow> 224<tablerow> 225<tablecell colspan="" rowspan=""> 226<paragraph role="paragraph" id="par_id3147553" xml-lang="en-US" l10n="U" oldref="57">Less than or Equal</paragraph> 227</tablecell> 228<tablecell colspan="" rowspan=""> 229<paragraph role="paragraph" id="par_id3153599" xml-lang="en-US" l10n="U" oldref="58">LEQ</paragraph> 230</tablecell> 231<tablecell colspan="" rowspan=""> 232<bookmark xml-lang="en-US" branch="hid/SW_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> 233<paragraph role="paragraph" id="par_id3151280" xml-lang="en-US" l10n="U" oldref="173">Example: <A1> LEQ 2 displays 1 (true), if the content of A1 is less than or equal to 2.</paragraph> 234</tablecell> 235</tablerow> 236<tablerow> 237<tablecell colspan="" rowspan=""> 238<paragraph role="paragraph" id="par_id3153729" xml-lang="en-US" l10n="U" oldref="61">Greater than or Equal</paragraph> 239</tablecell> 240<tablecell colspan="" rowspan=""> 241<paragraph role="paragraph" id="par_id3153751" xml-lang="en-US" l10n="U" oldref="62">GEQ</paragraph> 242</tablecell> 243<tablecell colspan="" rowspan=""> 244<bookmark xml-lang="en-US" branch="hid/SW_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> 245<paragraph role="paragraph" id="par_id3148898" xml-lang="en-US" l10n="U" oldref="174">Example: <A1> GEQ 2 displays 1 (true), if the content of A1 is greater than or equal to 2.</paragraph> 246</tablecell> 247</tablerow> 248<tablerow> 249<tablecell colspan="" rowspan=""> 250<paragraph role="paragraph" id="par_id3150836" xml-lang="en-US" l10n="U" oldref="65">Less</paragraph> 251</tablecell> 252<tablecell colspan="" rowspan=""> 253<paragraph role="paragraph" id="par_id3150859" xml-lang="en-US" l10n="U" oldref="66">L</paragraph> 254</tablecell> 255<tablecell colspan="" rowspan=""> 256<bookmark xml-lang="en-US" branch="hid/SW_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> 257<paragraph role="paragraph" id="par_id3155433" xml-lang="en-US" l10n="U" oldref="175">Example: <A1> L 2 displays 1 (true), if the content of A1 is less than 2.</paragraph> 258</tablecell> 259</tablerow> 260<tablerow> 261<tablecell colspan="" rowspan=""> 262<paragraph role="paragraph" id="par_id3150720" xml-lang="en-US" l10n="U" oldref="69">Greater</paragraph> 263</tablecell> 264<tablecell colspan="" rowspan=""> 265<paragraph role="paragraph" id="par_id3150743" xml-lang="en-US" l10n="U" oldref="70">G</paragraph> 266</tablecell> 267<tablecell colspan="" rowspan=""> 268<bookmark xml-lang="en-US" branch="hid/SW_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> 269<paragraph role="paragraph" id="par_id3147333" xml-lang="en-US" l10n="U" oldref="176">Example: <A1> G 2 displays 1 (true), if the content of A1 is greater than 2.</paragraph> 270</tablecell> 271</tablerow> 272<tablerow> 273<tablecell colspan="" rowspan=""> 274<paragraph role="paragraph" id="par_id3148408" xml-lang="en-US" l10n="U" oldref="73">Boolean Or</paragraph> 275</tablecell> 276<tablecell colspan="" rowspan=""> 277<paragraph role="paragraph" id="par_id3148430" xml-lang="en-US" l10n="U" oldref="74">OR</paragraph> 278</tablecell> 279<tablecell colspan="" rowspan=""> 280<bookmark xml-lang="en-US" branch="hid/SW_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> 281<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> 282</tablecell> 283</tablerow> 284<tablerow> 285<tablecell colspan="" rowspan=""> 286<paragraph role="paragraph" id="par_id3149434" xml-lang="en-US" l10n="U" oldref="76">Boolean X Or</paragraph> 287</tablecell> 288<tablecell colspan="" rowspan=""> 289<paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" l10n="U" oldref="77">XOR</paragraph> 290</tablecell> 291<tablecell colspan="" rowspan=""> 292<bookmark xml-lang="en-US" branch="hid/SW_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> 293<paragraph role="paragraph" id="par_id3147003" xml-lang="en-US" l10n="U" oldref="182">Example: 1 XOR 0 displays 1 (true)</paragraph> 294</tablecell> 295</tablerow> 296<tablerow> 297<tablecell colspan="" rowspan=""> 298<paragraph role="paragraph" id="par_id3152925" xml-lang="en-US" l10n="U" oldref="79">Boolean And</paragraph> 299</tablecell> 300<tablecell colspan="" rowspan=""> 301<paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" l10n="U" oldref="80">AND</paragraph> 302</tablecell> 303<tablecell colspan="" rowspan=""> 304<bookmark xml-lang="en-US" branch="hid/SW_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> 305<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U" oldref="183">Example: 1 AND 2 displays 1 (true)</paragraph> 306</tablecell> 307</tablerow> 308<tablerow> 309<tablecell colspan="" rowspan=""> 310<paragraph role="paragraph" id="par_id3153938" xml-lang="en-US" l10n="U" oldref="82">Boolean Not</paragraph> 311</tablecell> 312<tablecell colspan="" rowspan=""> 313<paragraph role="paragraph" id="par_id3153961" xml-lang="en-US" l10n="U" oldref="83">NOT</paragraph> 314</tablecell> 315<tablecell colspan="" rowspan=""> 316<bookmark xml-lang="en-US" branch="hid/SW_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> 317<paragraph role="paragraph" id="par_id3148655" xml-lang="en-US" l10n="U" oldref="184">Example: NOT 1 (true) displays 0 (false)</paragraph> 318</tablecell> 319</tablerow> 320</table> 321<bookmark xml-lang="en-US" branch="hid/SW_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> 322<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> 323<table id="tbl_id3154282"> 324<tablerow> 325<tablecell colspan="" rowspan=""> 326<paragraph role="paragraph" id="par_id3153176" xml-lang="en-US" l10n="U" oldref="86">Mean</paragraph> 327</tablecell> 328<tablecell colspan="" rowspan=""> 329<paragraph role="paragraph" id="par_id3154053" xml-lang="en-US" l10n="U" oldref="87">MEAN</paragraph> 330</tablecell> 331<tablecell colspan="" rowspan=""> 332<bookmark xml-lang="en-US" branch="hid/SW_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> 333<paragraph role="paragraph" id="par_id3145625" xml-lang="en-US" l10n="U" oldref="177">Example: MEAN 10|30|20 displays 20</paragraph> 334</tablecell> 335</tablerow> 336<tablerow> 337<tablecell colspan="" rowspan=""> 338<paragraph role="paragraph" id="par_id3145652" xml-lang="en-US" l10n="U" oldref="90">Minimum Value</paragraph> 339</tablecell> 340<tablecell colspan="" rowspan=""> 341<paragraph role="paragraph" id="par_id3155258" xml-lang="en-US" l10n="U" oldref="91">MIN</paragraph> 342</tablecell> 343<tablecell colspan="" rowspan=""> 344<bookmark xml-lang="en-US" branch="hid/SW_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> 345<paragraph role="paragraph" id="par_id3155304" xml-lang="en-US" l10n="U" oldref="178">Example: MIN 10|30|20 displays 10</paragraph> 346</tablecell> 347</tablerow> 348<tablerow> 349<tablecell colspan="" rowspan=""> 350<paragraph role="paragraph" id="par_id3153993" xml-lang="en-US" l10n="U" oldref="94">Maximum Value</paragraph> 351</tablecell> 352<tablecell colspan="" rowspan=""> 353<paragraph role="paragraph" id="par_id3154016" xml-lang="en-US" l10n="U" oldref="95">MAX</paragraph> 354</tablecell> 355<tablecell colspan="" rowspan=""> 356<bookmark xml-lang="en-US" branch="hid/SW_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> 357<paragraph role="paragraph" id="par_id3154748" xml-lang="en-US" l10n="U" oldref="179">Example: MAX 10|30|20 displays 30.00</paragraph> 358</tablecell> 359</tablerow> 360</table> 361<bookmark xml-lang="en-US" branch="hid/SW_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> 362<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> 363<table id="tbl_id3145120"> 364<tablerow> 365<tablecell colspan="" rowspan=""> 366<paragraph role="paragraph" id="par_id3145156" xml-lang="en-US" l10n="U" oldref="99">Sine</paragraph> 367</tablecell> 368<tablecell colspan="" rowspan=""> 369<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" l10n="U" oldref="100">SIN</paragraph> 370</tablecell> 371<tablecell colspan="" rowspan=""> 372<bookmark xml-lang="en-US" branch="hid/SW_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> 373<paragraph role="paragraph" id="par_id3153312" xml-lang="en-US" l10n="U" oldref="180">Example: SIN (PI/2)</paragraph> 374</tablecell> 375</tablerow> 376<tablerow> 377<tablecell colspan="" rowspan=""> 378<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US" l10n="U" oldref="103">Cosine</paragraph> 379</tablecell> 380<tablecell colspan="" rowspan=""> 381<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" l10n="U" oldref="104">COS</paragraph> 382</tablecell> 383<tablecell colspan="" rowspan=""> 384<bookmark xml-lang="en-US" branch="hid/SW_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> 385<paragraph role="paragraph" id="par_id3154554" xml-lang="en-US" l10n="U" oldref="185">Example: COS 1</paragraph> 386</tablecell> 387</tablerow> 388<tablerow> 389<tablecell colspan="" rowspan=""> 390<paragraph role="paragraph" id="par_id3150989" xml-lang="en-US" l10n="U" oldref="106">Tangent</paragraph> 391</tablecell> 392<tablecell colspan="" rowspan=""> 393<paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" l10n="U" oldref="107">TAN</paragraph> 394</tablecell> 395<tablecell colspan="" rowspan=""> 396<bookmark xml-lang="en-US" branch="hid/SW_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> 397<paragraph role="paragraph" id="par_id3149391" xml-lang="en-US" l10n="U" oldref="186">Example: TAN <A1></paragraph> 398</tablecell> 399</tablerow> 400<tablerow> 401<tablecell colspan="" rowspan=""> 402<paragraph role="paragraph" id="par_id3151032" xml-lang="en-US" l10n="U" oldref="109">Arc Sine</paragraph> 403</tablecell> 404<tablecell colspan="" rowspan=""> 405<paragraph role="paragraph" id="par_id3151055" xml-lang="en-US" l10n="U" oldref="110">ASIN</paragraph> 406</tablecell> 407<tablecell colspan="" rowspan=""> 408<bookmark xml-lang="en-US" branch="hid/SW_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> 409<paragraph role="paragraph" id="par_id3150588" xml-lang="en-US" l10n="U" oldref="187">Example: ASIN 1</paragraph> 410</tablecell> 411</tablerow> 412<tablerow> 413<tablecell colspan="" rowspan=""> 414<paragraph role="paragraph" id="par_id3150615" xml-lang="en-US" l10n="U" oldref="112">Arc Cosine</paragraph> 415</tablecell> 416<tablecell colspan="" rowspan=""> 417<paragraph role="paragraph" id="par_id3149728" xml-lang="en-US" l10n="U" oldref="113">ACOS</paragraph> 418</tablecell> 419<tablecell colspan="" rowspan=""> 420<bookmark xml-lang="en-US" branch="hid/SW_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> 421<paragraph role="paragraph" id="par_id3153833" xml-lang="en-US" l10n="U" oldref="188">Example: ACOS 1</paragraph> 422</tablecell> 423</tablerow> 424<tablerow> 425<tablecell colspan="" rowspan=""> 426<paragraph role="paragraph" id="par_id3153860" xml-lang="en-US" l10n="U" oldref="115">Arc Tangent</paragraph> 427</tablecell> 428<tablecell colspan="" rowspan=""> 429<paragraph role="paragraph" id="par_id3147057" xml-lang="en-US" l10n="U" oldref="116">ATAN</paragraph> 430</tablecell> 431<tablecell colspan="" rowspan=""> 432<bookmark xml-lang="en-US" branch="hid/SW_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> 433<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US" l10n="U" oldref="189">Example: ATAN 1</paragraph> 434</tablecell> 435</tablerow> 436</table> 437<paragraph role="heading" id="hd_id3150888" xml-lang="en-US" level="3" l10n="U" oldref="194">Variables for document properties</paragraph> 438<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> 439<table id="tbl_id3157507"> 440<tablerow> 441<tablecell colspan="" rowspan=""> 442<paragraph role="paragraph" id="par_id3157538" xml-lang="en-US" l10n="U" oldref="195">CHAR</paragraph> 443</tablecell> 444<tablecell colspan="" rowspan=""> 445<paragraph role="paragraph" id="par_id3152954" xml-lang="en-US" l10n="U" oldref="196">Number of characters in the document</paragraph> 446</tablecell> 447</tablerow> 448<tablerow> 449<tablecell colspan="" rowspan=""> 450<paragraph role="paragraph" id="par_id3152982" xml-lang="en-US" l10n="U" oldref="197">WORD</paragraph> 451</tablecell> 452<tablecell colspan="" rowspan=""> 453<paragraph role="paragraph" id="par_id3153005" xml-lang="en-US" l10n="U" oldref="198">Number of words in the document</paragraph> 454</tablecell> 455</tablerow> 456<tablerow> 457<tablecell colspan="" rowspan=""> 458<paragraph role="paragraph" id="par_id3152715" xml-lang="en-US" l10n="U" oldref="199">PARA</paragraph> 459</tablecell> 460<tablecell colspan="" rowspan=""> 461<paragraph role="paragraph" id="par_id3152738" xml-lang="en-US" l10n="U" oldref="200">Number of paragraphs in the document</paragraph> 462</tablecell> 463</tablerow> 464<tablerow> 465<tablecell colspan="" rowspan=""> 466<paragraph role="paragraph" id="par_id3148453" xml-lang="en-US" l10n="U" oldref="201">GRAPH</paragraph> 467</tablecell> 468<tablecell colspan="" rowspan=""> 469<paragraph role="paragraph" id="par_id3148476" xml-lang="en-US" l10n="U" oldref="202">Number of graphics in the document</paragraph> 470</tablecell> 471</tablerow> 472<tablerow> 473<tablecell colspan="" rowspan=""> 474<paragraph role="paragraph" id="par_id3151091" xml-lang="en-US" l10n="U" oldref="203">TABLES</paragraph> 475</tablecell> 476<tablecell colspan="" rowspan=""> 477<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="204">Number of tables in the document</paragraph> 478</tablecell> 479</tablerow> 480<tablerow> 481<tablecell colspan="" rowspan=""> 482<paragraph role="paragraph" id="par_id3151198" xml-lang="en-US" l10n="U" oldref="205">OLE</paragraph> 483</tablecell> 484<tablecell colspan="" rowspan=""> 485<paragraph role="paragraph" id="par_id3151220" xml-lang="en-US" l10n="U" oldref="206">Number of OLE objects in the document</paragraph> 486</tablecell> 487</tablerow> 488<tablerow> 489<tablecell colspan="" rowspan=""> 490<paragraph role="paragraph" id="par_id3146903" xml-lang="en-US" l10n="U" oldref="207">PAGE</paragraph> 491</tablecell> 492<tablecell colspan="" rowspan=""> 493<paragraph role="paragraph" id="par_id3146926" xml-lang="en-US" l10n="U" oldref="208">Total number of pages in the document</paragraph> 494</tablecell> 495</tablerow> 496</table> 497<paragraph role="heading" id="hd_id3146944" xml-lang="en-US" level="3" l10n="U" oldref="127">More Defined Values</paragraph> 498<table id="tbl_id3146957"> 499<tablerow> 500<tablecell colspan="" rowspan=""> 501<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US" l10n="U" oldref="128">PI</paragraph> 502</tablecell> 503<tablecell colspan="" rowspan=""> 504<paragraph role="paragraph" id="par_id3147343" xml-lang="en-US" l10n="U" oldref="129">PI</paragraph> 505</tablecell> 506<tablecell colspan="" rowspan=""> 507<paragraph role="paragraph" id="par_id3147366" xml-lang="en-US" l10n="U" oldref="130">3.1415...</paragraph> 508</tablecell> 509</tablerow> 510<tablerow> 511<tablecell colspan="" rowspan=""> 512<paragraph role="paragraph" id="par_id3147393" xml-lang="en-US" l10n="U" oldref="131">Euler's constant</paragraph> 513</tablecell> 514<tablecell colspan="" rowspan=""> 515<paragraph role="paragraph" id="par_id3147462" xml-lang="en-US" l10n="U" oldref="132">E</paragraph> 516</tablecell> 517<tablecell colspan="" rowspan=""> 518<paragraph role="paragraph" id="par_id3147485" xml-lang="en-US" l10n="CHG" oldref="133">2.71828...</paragraph> 519</tablecell> 520</tablerow> 521<tablerow> 522<tablecell colspan="" rowspan=""> 523<paragraph role="paragraph" id="par_id3145332" xml-lang="en-US" l10n="U" oldref="134">True</paragraph> 524</tablecell> 525<tablecell colspan="" rowspan=""> 526<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="135">TRUE</paragraph> 527</tablecell> 528<tablecell colspan="" rowspan=""> 529<paragraph role="paragraph" id="par_id3145378" xml-lang="en-US" l10n="U" oldref="136">not equal to 0</paragraph> 530</tablecell> 531</tablerow> 532<tablerow> 533<tablecell colspan="" rowspan=""> 534<paragraph role="paragraph" id="par_id3150362" xml-lang="en-US" l10n="U" oldref="137">False</paragraph> 535</tablecell> 536<tablecell colspan="" rowspan=""> 537<paragraph role="paragraph" id="par_id3150385" xml-lang="en-US" l10n="U" oldref="138">FALSE</paragraph> 538</tablecell> 539<tablecell colspan="" rowspan=""> 540<paragraph role="paragraph" id="par_id3149304" xml-lang="en-US" l10n="U" oldref="139">0</paragraph> 541</tablecell> 542</tablerow> 543</table> 544</body> 545</helpdocument> 546
