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