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