1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textswriter0214020000xml" indexer="include" status="PUBLISH"> 27<title id="tit" xml-lang="en-US">Formula</title> 28<filename>/text/swriter/02/14020000.xhp</filename> 29</topic> 30</meta> 31<body> 32<section id="formel"> 33<bookmark xml-lang="en-US" branch="index" id="bm_id3149687"> 34<bookmark_value>operators; in formulas</bookmark_value> 35<bookmark_value>statistical functions</bookmark_value> 36<bookmark_value>trigonometric functions</bookmark_value> 37<bookmark_value>pages;number of</bookmark_value> 38<bookmark_value>variables;document properties</bookmark_value> 39<bookmark_value>arithmetical operators in formulas</bookmark_value> 40</bookmark> 41<bookmark xml-lang="en-US" branch="hid/SW_HID_TBX_FORMULA_CALC" id="bm_id3155175" localize="false"/> 42<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> 43<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> 44</section> 45<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> 46<section id="syformel"> 47<table id="tbl_id3153634"> 48<tablerow> 49<tablecell colspan="" rowspan=""> 50<paragraph role="paragraph" id="par_id3155142" xml-lang="en-US" l10n="E"> 51<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> 52</image></paragraph> 53</tablecell> 54<tablecell colspan="" rowspan=""> 55<paragraph role="paragraph" id="par_id3150113" xml-lang="en-US" l10n="U" oldref="4">Formula</paragraph> 56</tablecell> 57</tablerow> 58</table> 59</section> 60<paragraph role="heading" id="hd_id3150691" xml-lang="en-US" level="2" l10n="U" oldref="5">Summary of Formula Options</paragraph> 61<paragraph role="heading" id="hd_id3155858" xml-lang="en-US" level="3" l10n="U" oldref="6">Basic Calculation Functions</paragraph> 62<table id="tbl_id3155870"> 63<tablerow> 64<tablecell colspan="" rowspan=""> 65<paragraph role="paragraph" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="7">Addition</paragraph> 66</tablecell> 67<tablecell colspan="" rowspan=""> 68<paragraph role="paragraph" id="par_id3150563" xml-lang="en-US" l10n="U" oldref="8">+</paragraph> 69</tablecell> 70<tablecell colspan="" rowspan=""> 71<paragraph role="paragraph" id="par_id3149831" xml-lang="en-US" l10n="U" oldref="9">Calculates the total.</paragraph> 72<paragraph role="paragraph" id="par_id3149845" xml-lang="en-US" l10n="U" oldref="161">Example: <A1> + 8</paragraph> 73</tablecell> 74</tablerow> 75<tablerow> 76<tablecell colspan="" rowspan=""> 77<paragraph role="paragraph" id="par_id3156097" xml-lang="en-US" l10n="U" oldref="11">Subtraction</paragraph> 78</tablecell> 79<tablecell colspan="" rowspan=""> 80<paragraph role="paragraph" id="par_id3150087" xml-lang="en-US" l10n="CHG" oldref="12">-</paragraph> 81</tablecell> 82<tablecell colspan="" rowspan=""> 83<paragraph role="paragraph" id="par_id3153122" xml-lang="en-US" l10n="U" oldref="13">Calculates the difference</paragraph> 84<paragraph role="paragraph" id="par_id3153135" xml-lang="en-US" l10n="U" oldref="162">Example: 10 - <B5></paragraph> 85</tablecell> 86</tablerow> 87<tablerow> 88<tablecell colspan="" rowspan=""> 89<paragraph role="paragraph" id="par_id3149646" xml-lang="en-US" l10n="U" oldref="15">Multiplication</paragraph> 90</tablecell> 91<tablecell colspan="" rowspan=""> 92<paragraph role="paragraph" id="par_id3154038" xml-lang="en-US" l10n="U" oldref="16">MUL or *</paragraph> 93</tablecell> 94<tablecell colspan="" rowspan=""> 95<paragraph role="paragraph" id="par_id3149965" xml-lang="en-US" l10n="U" oldref="17">Calculates the product.</paragraph> 96<paragraph role="paragraph" id="par_id3149603" xml-lang="en-US" l10n="U" oldref="163">Example: 7 MUL 9</paragraph> 97</tablecell> 98</tablerow> 99<tablerow> 100<tablecell colspan="" rowspan=""> 101<paragraph role="paragraph" id="par_id3145096" xml-lang="en-US" l10n="U" oldref="19">Division</paragraph> 102</tablecell> 103<tablecell colspan="" rowspan=""> 104<paragraph role="paragraph" id="par_id3149570" xml-lang="en-US" l10n="U" oldref="20">DIV or /</paragraph> 105</tablecell> 106<tablecell colspan="" rowspan=""> 107<paragraph role="paragraph" id="par_id3149592" xml-lang="en-US" l10n="U" oldref="21">Calculates the quotient</paragraph> 108<paragraph role="paragraph" id="par_id3156243" xml-lang="en-US" l10n="U" oldref="164">Example: 100 DIV 15</paragraph> 109</tablecell> 110</tablerow> 111</table> 112<paragraph role="heading" id="hd_id3156260" xml-lang="en-US" level="3" l10n="U" oldref="23">Basic Functions in the Submenu</paragraph> 113<table id="tbl_id3148926"> 114<tablerow> 115<tablecell colspan="" rowspan=""> 116<paragraph role="paragraph" id="par_id3145185" xml-lang="en-US" l10n="U" oldref="24">Sum</paragraph> 117</tablecell> 118<tablecell colspan="" rowspan=""> 119<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" l10n="U" oldref="25">SUM</paragraph> 120</tablecell> 121<tablecell colspan="" rowspan=""> 122<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_SUM" id="bm_id3154400" localize="false"/> 123<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> 124<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> 125</tablecell> 126</tablerow> 127<tablerow> 128<tablecell colspan="" rowspan=""> 129<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US" l10n="U" oldref="28">Round</paragraph> 130</tablecell> 131<tablecell colspan="" rowspan=""> 132<paragraph role="paragraph" id="par_id3145598" xml-lang="en-US" l10n="U" oldref="29">ROUND</paragraph> 133</tablecell> 134<tablecell colspan="" rowspan=""> 135<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_ROUND" id="bm_id3154851" localize="false"/> 136<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> 137<paragraph role="paragraph" id="par_id3154862" xml-lang="en-US" l10n="U" oldref="166">Example: 15.678 ROUND 2 displays 15.68</paragraph> 138</tablecell> 139</tablerow> 140<tablerow> 141<tablecell colspan="" rowspan=""> 142<paragraph role="paragraph" id="par_id3148687" xml-lang="en-US" l10n="U" oldref="32">Percent</paragraph> 143</tablecell> 144<tablecell colspan="" rowspan=""> 145<paragraph role="paragraph" id="par_id3155930" xml-lang="en-US" l10n="U" oldref="33">PHD</paragraph> 146</tablecell> 147<tablecell colspan="" rowspan=""> 148<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_PHD" id="bm_id3149981" localize="false"/> 149<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> 150<paragraph role="paragraph" id="par_id3149991" xml-lang="en-US" l10n="U" oldref="167">Example: 10 + 15 PHD displays 10.15</paragraph> 151</tablecell> 152</tablerow> 153<tablerow> 154<tablecell colspan="" rowspan=""> 155<paragraph role="paragraph" id="par_id3153016" xml-lang="en-US" l10n="U" oldref="36">Square Root</paragraph> 156</tablecell> 157<tablecell colspan="" rowspan=""> 158<paragraph role="paragraph" id="par_id3153038" xml-lang="en-US" l10n="U" oldref="37">SQRT</paragraph> 159</tablecell> 160<tablecell colspan="" rowspan=""> 161<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_SQRT" id="bm_id3153074" localize="false"/> 162<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> 163<paragraph role="paragraph" id="par_id3153882" xml-lang="en-US" l10n="U" oldref="168">Example: SQRT 25 displays 5.00</paragraph> 164</tablecell> 165</tablerow> 166<tablerow> 167<tablecell colspan="" rowspan=""> 168<paragraph role="paragraph" id="par_id3153909" xml-lang="en-US" l10n="U" oldref="40">Power</paragraph> 169</tablecell> 170<tablecell colspan="" rowspan=""> 171<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US" l10n="U" oldref="41">POW</paragraph> 172</tablecell> 173<tablecell colspan="" rowspan=""> 174<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_POW" id="bm_id3149779" localize="false"/> 175<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> 176<paragraph role="paragraph" id="par_id3149789" xml-lang="en-US" l10n="U" oldref="169">Example: 2 POW 8 displays 256.00</paragraph> 177</tablecell> 178</tablerow> 179</table> 180<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_POP_OPS" id="bm_id3150227" localize="false"/> 181<paragraph role="heading" id="hd_id3150216" xml-lang="en-US" level="3" l10n="U" oldref="44">Operators</paragraph> 182<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> 183<table id="tbl_id3145218"> 184<tablerow> 185<tablecell colspan="" rowspan=""> 186<paragraph role="paragraph" id="par_id3150316" xml-lang="en-US" l10n="U" oldref="45">List Separator</paragraph> 187</tablecell> 188<tablecell colspan="" rowspan=""> 189<paragraph role="paragraph" id="par_id3150339" xml-lang="en-US" l10n="U" oldref="46">|</paragraph> 190</tablecell> 191<tablecell colspan="" rowspan=""> 192<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_LISTSEP" id="bm_id3153110" localize="false"/> 193<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> 194<paragraph role="paragraph" id="par_id3155817" xml-lang="en-US" l10n="U" oldref="170">Example of using a list:</paragraph> 195<paragraph role="paragraph" id="par_id3155830" xml-lang="en-US" l10n="U" oldref="212">MIN 10|20|50|<C6>|<A2:B6>|20</paragraph> 196</tablecell> 197</tablerow> 198<tablerow> 199<tablecell colspan="" rowspan=""> 200<paragraph role="paragraph" id="par_id3147012" xml-lang="en-US" l10n="U" oldref="49">Equal</paragraph> 201</tablecell> 202<tablecell colspan="" rowspan=""> 203<paragraph role="paragraph" id="par_id3147034" xml-lang="en-US" l10n="U" oldref="50">EQ or ==</paragraph> 204</tablecell> 205<tablecell colspan="" rowspan=""> 206<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_EQ" id="bm_id3150947" localize="false"/> 207<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> 208<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> 209</tablecell> 210</tablerow> 211<tablerow> 212<tablecell colspan="" rowspan=""> 213<paragraph role="paragraph" id="par_id3154370" xml-lang="en-US" l10n="U" oldref="53">Not Equal</paragraph> 214</tablecell> 215<tablecell colspan="" rowspan=""> 216<paragraph role="paragraph" id="par_id3150503" xml-lang="en-US" l10n="U" oldref="54">NEQ or !=</paragraph> 217</tablecell> 218<tablecell colspan="" rowspan=""> 219<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_NEQ" id="bm_id3150537" localize="false"/> 220<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"/> 233<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> 234<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> 235</tablecell> 236</tablerow> 237<tablerow> 238<tablecell colspan="" rowspan=""> 239<paragraph role="paragraph" id="par_id3153729" xml-lang="en-US" l10n="U" oldref="61">Greater than or Equal</paragraph> 240</tablecell> 241<tablecell colspan="" rowspan=""> 242<paragraph role="paragraph" id="par_id3153751" xml-lang="en-US" l10n="U" oldref="62">GEQ</paragraph> 243</tablecell> 244<tablecell colspan="" rowspan=""> 245<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_GEQ" id="bm_id3148887" localize="false"/> 246<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> 247<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> 248</tablecell> 249</tablerow> 250<tablerow> 251<tablecell colspan="" rowspan=""> 252<paragraph role="paragraph" id="par_id3150836" xml-lang="en-US" l10n="U" oldref="65">Less</paragraph> 253</tablecell> 254<tablecell colspan="" rowspan=""> 255<paragraph role="paragraph" id="par_id3150859" xml-lang="en-US" l10n="U" oldref="66">L</paragraph> 256</tablecell> 257<tablecell colspan="" rowspan=""> 258<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_LES" id="bm_id3155422" localize="false"/> 259<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: <A1> 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/SW_HID_MN_CALC_GRE" id="bm_id3147322" localize="false"/> 272<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> 273<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> 274</tablecell> 275</tablerow> 276<tablerow> 277<tablecell colspan="" rowspan=""> 278<paragraph role="paragraph" id="par_id3148408" xml-lang="en-US" l10n="U" oldref="73">Boolean Or</paragraph> 279</tablecell> 280<tablecell colspan="" rowspan=""> 281<paragraph role="paragraph" id="par_id3148430" xml-lang="en-US" l10n="U" oldref="74">OR</paragraph> 282</tablecell> 283<tablecell colspan="" rowspan=""> 284<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_OR" id="bm_id3150286" localize="false"/> 285<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> 286<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> 287</tablecell> 288</tablerow> 289<tablerow> 290<tablecell colspan="" rowspan=""> 291<paragraph role="paragraph" id="par_id3149434" xml-lang="en-US" l10n="U" oldref="76">Boolean X Or</paragraph> 292</tablecell> 293<tablecell colspan="" rowspan=""> 294<paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" l10n="U" oldref="77">XOR</paragraph> 295</tablecell> 296<tablecell colspan="" rowspan=""> 297<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_XOR" id="bm_id3146992" localize="false"/> 298<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> 299<paragraph role="paragraph" id="par_id3147003" xml-lang="en-US" l10n="U" oldref="182">Example: 1 XOR 0 displays 1 (true)</paragraph> 300</tablecell> 301</tablerow> 302<tablerow> 303<tablecell colspan="" rowspan=""> 304<paragraph role="paragraph" id="par_id3152925" xml-lang="en-US" l10n="U" oldref="79">Boolean And</paragraph> 305</tablecell> 306<tablecell colspan="" rowspan=""> 307<paragraph role="paragraph" id="par_id3152948" xml-lang="en-US" l10n="U" oldref="80">AND</paragraph> 308</tablecell> 309<tablecell colspan="" rowspan=""> 310<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_AND" id="bm_id3153803" localize="false"/> 311<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> 312<paragraph role="paragraph" id="par_id3153814" xml-lang="en-US" l10n="U" oldref="183">Example: 1 AND 2 displays 1 (true)</paragraph> 313</tablecell> 314</tablerow> 315<tablerow> 316<tablecell colspan="" rowspan=""> 317<paragraph role="paragraph" id="par_id3153938" xml-lang="en-US" l10n="U" oldref="82">Boolean Not</paragraph> 318</tablecell> 319<tablecell colspan="" rowspan=""> 320<paragraph role="paragraph" id="par_id3153961" xml-lang="en-US" l10n="U" oldref="83">NOT</paragraph> 321</tablecell> 322<tablecell colspan="" rowspan=""> 323<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_NOT" id="bm_id3148644" localize="false"/> 324<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> 325<paragraph role="paragraph" id="par_id3148655" xml-lang="en-US" l10n="U" oldref="184">Example: NOT 1 (true) displays 0 (false)</paragraph> 326</tablecell> 327</tablerow> 328</table> 329<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_POP_STATISTICS" id="bm_id3154251" localize="false"/> 330<paragraph role="heading" id="hd_id3154240" xml-lang="en-US" level="3" l10n="U" oldref="85">Statistical Functions</paragraph> 331<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> 332<table id="tbl_id3154282"> 333<tablerow> 334<tablecell colspan="" rowspan=""> 335<paragraph role="paragraph" id="par_id3153176" xml-lang="en-US" l10n="U" oldref="86">Mean</paragraph> 336</tablecell> 337<tablecell colspan="" rowspan=""> 338<paragraph role="paragraph" id="par_id3154053" xml-lang="en-US" l10n="U" oldref="87">MEAN</paragraph> 339</tablecell> 340<tablecell colspan="" rowspan=""> 341<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_MEAN" id="bm_id3154087" localize="false"/> 342<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> 343<paragraph role="paragraph" id="par_id3145625" xml-lang="en-US" l10n="U" oldref="177">Example: MEAN 10|30|20 displays 20</paragraph> 344</tablecell> 345</tablerow> 346<tablerow> 347<tablecell colspan="" rowspan=""> 348<paragraph role="paragraph" id="par_id3145652" xml-lang="en-US" l10n="U" oldref="90">Minimum Value</paragraph> 349</tablecell> 350<tablecell colspan="" rowspan=""> 351<paragraph role="paragraph" id="par_id3155258" xml-lang="en-US" l10n="U" oldref="91">MIN</paragraph> 352</tablecell> 353<tablecell colspan="" rowspan=""> 354<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_MIN" id="bm_id3155292" localize="false"/> 355<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> 356<paragraph role="paragraph" id="par_id3155304" xml-lang="en-US" l10n="U" oldref="178">Example: MIN 10|30|20 displays 10</paragraph> 357</tablecell> 358</tablerow> 359<tablerow> 360<tablecell colspan="" rowspan=""> 361<paragraph role="paragraph" id="par_id3153993" xml-lang="en-US" l10n="U" oldref="94">Maximum Value</paragraph> 362</tablecell> 363<tablecell colspan="" rowspan=""> 364<paragraph role="paragraph" id="par_id3154016" xml-lang="en-US" l10n="U" oldref="95">MAX</paragraph> 365</tablecell> 366<tablecell colspan="" rowspan=""> 367<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_MAX" id="bm_id3154737" localize="false"/> 368<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> 369<paragraph role="paragraph" id="par_id3154748" xml-lang="en-US" l10n="U" oldref="179">Example: MAX 10|30|20 displays 30.00</paragraph> 370</tablecell> 371</tablerow> 372</table> 373<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_POP_FUNC" id="bm_id3153211" localize="false"/> 374<paragraph role="heading" id="hd_id3153200" xml-lang="en-US" level="3" l10n="U" oldref="98">Trigonometric Functions</paragraph> 375<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> 376<table id="tbl_id3145120"> 377<tablerow> 378<tablecell colspan="" rowspan=""> 379<paragraph role="paragraph" id="par_id3145156" xml-lang="en-US" l10n="U" oldref="99">Sine</paragraph> 380</tablecell> 381<tablecell colspan="" rowspan=""> 382<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" l10n="U" oldref="100">SIN</paragraph> 383</tablecell> 384<tablecell colspan="" rowspan=""> 385<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_SIN" id="bm_id3149541" localize="false"/> 386<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> 387<paragraph role="paragraph" id="par_id3153312" xml-lang="en-US" l10n="U" oldref="180">Example: SIN (PI/2)</paragraph> 388</tablecell> 389</tablerow> 390<tablerow> 391<tablecell colspan="" rowspan=""> 392<paragraph role="paragraph" id="par_id3153340" xml-lang="en-US" l10n="U" oldref="103">Cosine</paragraph> 393</tablecell> 394<tablecell colspan="" rowspan=""> 395<paragraph role="paragraph" id="par_id3154510" xml-lang="en-US" l10n="U" oldref="104">COS</paragraph> 396</tablecell> 397<tablecell colspan="" rowspan=""> 398<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_COS" id="bm_id3154544" localize="false"/> 399<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> 400<paragraph role="paragraph" id="par_id3154554" xml-lang="en-US" l10n="U" oldref="185">Example: COS 1</paragraph> 401</tablecell> 402</tablerow> 403<tablerow> 404<tablecell colspan="" rowspan=""> 405<paragraph role="paragraph" id="par_id3150989" xml-lang="en-US" l10n="U" oldref="106">Tangent</paragraph> 406</tablecell> 407<tablecell colspan="" rowspan=""> 408<paragraph role="paragraph" id="par_id3151012" xml-lang="en-US" l10n="U" oldref="107">TAN</paragraph> 409</tablecell> 410<tablecell colspan="" rowspan=""> 411<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_TAN" id="bm_id3149380" localize="false"/> 412<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> 413<paragraph role="paragraph" id="par_id3149391" xml-lang="en-US" l10n="U" oldref="186">Example: TAN <A1></paragraph> 414</tablecell> 415</tablerow> 416<tablerow> 417<tablecell colspan="" rowspan=""> 418<paragraph role="paragraph" id="par_id3151032" xml-lang="en-US" l10n="U" oldref="109">Arc Sine</paragraph> 419</tablecell> 420<tablecell colspan="" rowspan=""> 421<paragraph role="paragraph" id="par_id3151055" xml-lang="en-US" l10n="U" oldref="110">ASIN</paragraph> 422</tablecell> 423<tablecell colspan="" rowspan=""> 424<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_ASIN" id="bm_id3150577" localize="false"/> 425<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> 426<paragraph role="paragraph" id="par_id3150588" xml-lang="en-US" l10n="U" oldref="187">Example: ASIN 1</paragraph> 427</tablecell> 428</tablerow> 429<tablerow> 430<tablecell colspan="" rowspan=""> 431<paragraph role="paragraph" id="par_id3150615" xml-lang="en-US" l10n="U" oldref="112">Arc Cosine</paragraph> 432</tablecell> 433<tablecell colspan="" rowspan=""> 434<paragraph role="paragraph" id="par_id3149728" xml-lang="en-US" l10n="U" oldref="113">ACOS</paragraph> 435</tablecell> 436<tablecell colspan="" rowspan=""> 437<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_ACOS" id="bm_id3153822" localize="false"/> 438<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> 439<paragraph role="paragraph" id="par_id3153833" xml-lang="en-US" l10n="U" oldref="188">Example: ACOS 1</paragraph> 440</tablecell> 441</tablerow> 442<tablerow> 443<tablecell colspan="" rowspan=""> 444<paragraph role="paragraph" id="par_id3153860" xml-lang="en-US" l10n="U" oldref="115">Arc Tangent</paragraph> 445</tablecell> 446<tablecell colspan="" rowspan=""> 447<paragraph role="paragraph" id="par_id3147057" xml-lang="en-US" l10n="U" oldref="116">ATAN</paragraph> 448</tablecell> 449<tablecell colspan="" rowspan=""> 450<bookmark xml-lang="en-US" branch="hid/SW_HID_MN_CALC_ATAN" id="bm_id3147091" localize="false"/> 451<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> 452<paragraph role="paragraph" id="par_id3147102" xml-lang="en-US" l10n="U" oldref="189">Example: ATAN 1</paragraph> 453</tablecell> 454</tablerow> 455</table> 456<paragraph role="heading" id="hd_id3150888" xml-lang="en-US" level="3" l10n="U" oldref="194">Variables for document properties</paragraph> 457<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> 458<table id="tbl_id3157507"> 459<tablerow> 460<tablecell colspan="" rowspan=""> 461<paragraph role="paragraph" id="par_id3157538" xml-lang="en-US" l10n="U" oldref="195">CHAR</paragraph> 462</tablecell> 463<tablecell colspan="" rowspan=""> 464<paragraph role="paragraph" id="par_id3152954" xml-lang="en-US" l10n="U" oldref="196">Number of characters in the document</paragraph> 465</tablecell> 466</tablerow> 467<tablerow> 468<tablecell colspan="" rowspan=""> 469<paragraph role="paragraph" id="par_id3152982" xml-lang="en-US" l10n="U" oldref="197">WORD</paragraph> 470</tablecell> 471<tablecell colspan="" rowspan=""> 472<paragraph role="paragraph" id="par_id3153005" xml-lang="en-US" l10n="U" oldref="198">Number of words in the document</paragraph> 473</tablecell> 474</tablerow> 475<tablerow> 476<tablecell colspan="" rowspan=""> 477<paragraph role="paragraph" id="par_id3152715" xml-lang="en-US" l10n="U" oldref="199">PARA</paragraph> 478</tablecell> 479<tablecell colspan="" rowspan=""> 480<paragraph role="paragraph" id="par_id3152738" xml-lang="en-US" l10n="U" oldref="200">Number of paragraphs in the document</paragraph> 481</tablecell> 482</tablerow> 483<tablerow> 484<tablecell colspan="" rowspan=""> 485<paragraph role="paragraph" id="par_id3148453" xml-lang="en-US" l10n="U" oldref="201">GRAPH</paragraph> 486</tablecell> 487<tablecell colspan="" rowspan=""> 488<paragraph role="paragraph" id="par_id3148476" xml-lang="en-US" l10n="U" oldref="202">Number of graphics in the document</paragraph> 489</tablecell> 490</tablerow> 491<tablerow> 492<tablecell colspan="" rowspan=""> 493<paragraph role="paragraph" id="par_id3151091" xml-lang="en-US" l10n="U" oldref="203">TABLES</paragraph> 494</tablecell> 495<tablecell colspan="" rowspan=""> 496<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="204">Number of tables in the document</paragraph> 497</tablecell> 498</tablerow> 499<tablerow> 500<tablecell colspan="" rowspan=""> 501<paragraph role="paragraph" id="par_id3151198" xml-lang="en-US" l10n="U" oldref="205">OLE</paragraph> 502</tablecell> 503<tablecell colspan="" rowspan=""> 504<paragraph role="paragraph" id="par_id3151220" xml-lang="en-US" l10n="U" oldref="206">Number of OLE objects in the document</paragraph> 505</tablecell> 506</tablerow> 507<tablerow> 508<tablecell colspan="" rowspan=""> 509<paragraph role="paragraph" id="par_id3146903" xml-lang="en-US" l10n="U" oldref="207">PAGE</paragraph> 510</tablecell> 511<tablecell colspan="" rowspan=""> 512<paragraph role="paragraph" id="par_id3146926" xml-lang="en-US" l10n="U" oldref="208">Total number of pages in the document</paragraph> 513</tablecell> 514</tablerow> 515</table> 516<paragraph role="heading" id="hd_id3146944" xml-lang="en-US" level="3" l10n="U" oldref="127">More Defined Values</paragraph> 517<table id="tbl_id3146957"> 518<tablerow> 519<tablecell colspan="" rowspan=""> 520<paragraph role="paragraph" id="par_id3153562" xml-lang="en-US" l10n="U" oldref="128">PI</paragraph> 521</tablecell> 522<tablecell colspan="" rowspan=""> 523<paragraph role="paragraph" id="par_id3147343" xml-lang="en-US" l10n="U" oldref="129">PI</paragraph> 524</tablecell> 525<tablecell colspan="" rowspan=""> 526<paragraph role="paragraph" id="par_id3147366" xml-lang="en-US" l10n="U" oldref="130">3.1415...</paragraph> 527</tablecell> 528</tablerow> 529<tablerow> 530<tablecell colspan="" rowspan=""> 531<paragraph role="paragraph" id="par_id3147393" xml-lang="en-US" l10n="U" oldref="131">Euler's constant</paragraph> 532</tablecell> 533<tablecell colspan="" rowspan=""> 534<paragraph role="paragraph" id="par_id3147462" xml-lang="en-US" l10n="U" oldref="132">E</paragraph> 535</tablecell> 536<tablecell colspan="" rowspan=""> 537<paragraph role="paragraph" id="par_id3147485" xml-lang="en-US" l10n="CHG" oldref="133">2.71828...</paragraph> 538</tablecell> 539</tablerow> 540<tablerow> 541<tablecell colspan="" rowspan=""> 542<paragraph role="paragraph" id="par_id3145332" xml-lang="en-US" l10n="U" oldref="134">True</paragraph> 543</tablecell> 544<tablecell colspan="" rowspan=""> 545<paragraph role="paragraph" id="par_id3145355" xml-lang="en-US" l10n="U" oldref="135">TRUE</paragraph> 546</tablecell> 547<tablecell colspan="" rowspan=""> 548<paragraph role="paragraph" id="par_id3145378" xml-lang="en-US" l10n="U" oldref="136">not equal to 0</paragraph> 549</tablecell> 550</tablerow> 551<tablerow> 552<tablecell colspan="" rowspan=""> 553<paragraph role="paragraph" id="par_id3150362" xml-lang="en-US" l10n="U" oldref="137">False</paragraph> 554</tablecell> 555<tablecell colspan="" rowspan=""> 556<paragraph role="paragraph" id="par_id3150385" xml-lang="en-US" l10n="U" oldref="138">FALSE</paragraph> 557</tablecell> 558<tablecell colspan="" rowspan=""> 559<paragraph role="paragraph" id="par_id3149304" xml-lang="en-US" l10n="U" oldref="139">0</paragraph> 560</tablecell> 561</tablerow> 562</table> 563</body> 564</helpdocument> 565
