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="textscalc0104060199xml" indexer="include" status="PUBLISH"> 27<title id="tit" xml-lang="en-US">Operators in $[officename] Calc</title> 28<filename>/text/scalc/01/04060199.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3156445"> 33<bookmark_value>formulas; operators</bookmark_value> 34<bookmark_value>operators; formula functions</bookmark_value> 35<bookmark_value>division sign, see also operators</bookmark_value> 36<bookmark_value>multiplication sign, see also operators</bookmark_value> 37<bookmark_value>minus sign, see also operators</bookmark_value> 38<bookmark_value>plus sign, see also operators</bookmark_value> 39<bookmark_value>text operators</bookmark_value> 40<bookmark_value>comparisons;operators in Calc</bookmark_value> 41<bookmark_value>arithmetical operators</bookmark_value> 42<bookmark_value>reference operators</bookmark_value> 43</bookmark><comment>mw added 7 new index entries</comment><paragraph role="heading" id="hd_id3156445" xml-lang="en-US" level="1" l10n="U" oldref="1">Operators in $[officename] Calc</paragraph> 44<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US" l10n="U" oldref="2">You can use the following operators in $[officename] Calc:</paragraph> 45<paragraph role="heading" id="hd_id3153066" xml-lang="en-US" level="2" l10n="U" oldref="3">Arithmetical Operators</paragraph> 46<paragraph role="paragraph" id="par_id3148601" xml-lang="en-US" l10n="U" oldref="4">These operators return numerical results.</paragraph> 47<table id="tbl_id3151240"> 48<tablerow> 49<tablecell colspan="" rowspan=""> 50<paragraph role="tablehead" id="par_id3144768" xml-lang="en-US" l10n="U" oldref="5">Operator</paragraph> 51</tablecell> 52<tablecell colspan="" rowspan=""> 53<paragraph role="tablehead" id="par_id3157982" xml-lang="en-US" l10n="U" oldref="6">Name</paragraph> 54</tablecell> 55<tablecell colspan="" rowspan=""> 56<paragraph role="tablehead" id="par_id3159096" xml-lang="en-US" l10n="U" oldref="7">Example</paragraph> 57</tablecell> 58</tablerow> 59<tablerow> 60<tablecell colspan="" rowspan=""> 61<paragraph role="tablecontent" id="par_id3149126" xml-lang="en-US" l10n="U" oldref="8">+ (Plus)</paragraph> 62</tablecell> 63<tablecell colspan="" rowspan=""> 64<paragraph role="tablecontent" id="par_id3150892" xml-lang="en-US" l10n="U" oldref="9">Addition</paragraph> 65</tablecell> 66<tablecell colspan="" rowspan=""> 67<paragraph role="tablecontent" id="par_id3153247" xml-lang="en-US" l10n="U" oldref="10">1+1</paragraph> 68</tablecell> 69</tablerow> 70<tablerow> 71<tablecell colspan="" rowspan=""> 72<paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US" l10n="U" oldref="11">- (Minus)</paragraph> 73</tablecell> 74<tablecell colspan="" rowspan=""> 75<paragraph role="tablecontent" id="par_id3145362" xml-lang="en-US" l10n="U" oldref="12">Subtraction</paragraph> 76</tablecell> 77<tablecell colspan="" rowspan=""> 78<paragraph role="tablecontent" id="par_id3153554" xml-lang="en-US" l10n="U" oldref="13">2-1</paragraph> 79</tablecell> 80</tablerow> 81<tablerow> 82<tablecell colspan="" rowspan=""> 83<paragraph role="tablecontent" id="par_id3153808" xml-lang="en-US" l10n="U" oldref="14">- (Minus)</paragraph> 84</tablecell> 85<tablecell colspan="" rowspan=""> 86<paragraph role="tablecontent" id="par_id3151193" xml-lang="en-US" l10n="U" oldref="15">Negation</paragraph> 87</tablecell> 88<tablecell colspan="" rowspan=""> 89<paragraph role="tablecontent" id="par_id3154712" xml-lang="en-US" l10n="U" oldref="16">-5</paragraph> 90</tablecell> 91</tablerow> 92<tablerow> 93<tablecell colspan="" rowspan=""> 94<paragraph role="tablecontent" id="par_id3149873" xml-lang="en-US" l10n="U" oldref="17">* (asterisk)</paragraph> 95</tablecell> 96<tablecell colspan="" rowspan=""> 97<paragraph role="tablecontent" id="par_id3147504" xml-lang="en-US" l10n="U" oldref="18">Multiplication</paragraph> 98</tablecell> 99<tablecell colspan="" rowspan=""> 100<paragraph role="tablecontent" id="par_id3149055" xml-lang="en-US" l10n="U" oldref="19">2*2</paragraph> 101</tablecell> 102</tablerow> 103<tablerow> 104<tablecell colspan="" rowspan=""> 105<paragraph role="tablecontent" id="par_id3151341" xml-lang="en-US" l10n="U" oldref="20">/ (Slash)</paragraph> 106</tablecell> 107<tablecell colspan="" rowspan=""> 108<paragraph role="tablecontent" id="par_id3159260" xml-lang="en-US" l10n="U" oldref="21">Division</paragraph> 109</tablecell> 110<tablecell colspan="" rowspan=""> 111<paragraph role="tablecontent" id="par_id3153027" xml-lang="en-US" l10n="U" oldref="22">9/3</paragraph> 112</tablecell> 113</tablerow> 114<tablerow> 115<tablecell colspan="" rowspan=""> 116<paragraph role="tablecontent" id="par_id3156396" xml-lang="en-US" l10n="U" oldref="23">% (Percent)</paragraph> 117</tablecell> 118<tablecell colspan="" rowspan=""> 119<paragraph role="tablecontent" id="par_id3150372" xml-lang="en-US" l10n="U" oldref="24">Percent</paragraph> 120</tablecell> 121<tablecell colspan="" rowspan=""> 122<paragraph role="tablecontent" id="par_id3145632" xml-lang="en-US" l10n="U" oldref="25">15%</paragraph> 123</tablecell> 124</tablerow> 125<tablerow> 126<tablecell colspan="" rowspan=""> 127<paragraph role="tablecontent" id="par_id3149722" xml-lang="en-US" l10n="U" oldref="26">^ (Caret)</paragraph> 128</tablecell> 129<tablecell colspan="" rowspan=""> 130<paragraph role="tablecontent" id="par_id3159127" xml-lang="en-US" l10n="U" oldref="27">Exponentiation</paragraph> 131</tablecell> 132<tablecell colspan="" rowspan=""> 133<paragraph role="tablecontent" id="par_id3157873" xml-lang="en-US" l10n="U" oldref="28">3^2</paragraph> 134</tablecell> 135</tablerow> 136</table> 137<paragraph role="heading" id="hd_id3152981" xml-lang="en-US" level="2" l10n="U" oldref="29">Comparative operators</paragraph> 138<paragraph role="paragraph" id="par_id3157902" xml-lang="en-US" l10n="U" oldref="30">These operators return either true or false.</paragraph> 139<table id="tbl_id3148725"> 140<tablerow> 141<tablecell colspan="" rowspan=""> 142<paragraph role="tablehead" id="par_id3149889" xml-lang="en-US" l10n="U" oldref="31">Operator</paragraph> 143</tablecell> 144<tablecell colspan="" rowspan=""> 145<paragraph role="tablehead" id="par_id3150743" xml-lang="en-US" l10n="U" oldref="32">Name</paragraph> 146</tablecell> 147<tablecell colspan="" rowspan=""> 148<paragraph role="tablehead" id="par_id3146877" xml-lang="en-US" l10n="U" oldref="33">Example</paragraph> 149</tablecell> 150</tablerow> 151<tablerow> 152<tablecell colspan="" rowspan=""> 153<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US" l10n="U" oldref="34">= (equal sign)</paragraph> 154</tablecell> 155<tablecell colspan="" rowspan=""> 156<paragraph role="tablecontent" id="par_id3154845" xml-lang="en-US" l10n="U" oldref="35">Equal</paragraph> 157</tablecell> 158<tablecell colspan="" rowspan=""> 159<paragraph role="tablecontent" id="par_id3154546" xml-lang="en-US" l10n="U" oldref="36">A1=B1</paragraph> 160</tablecell> 161</tablerow> 162<tablerow> 163<tablecell colspan="" rowspan=""> 164<paragraph role="tablecontent" id="par_id3154807" xml-lang="en-US" l10n="U" oldref="37">> (Greater than)</paragraph> 165</tablecell> 166<tablecell colspan="" rowspan=""> 167<paragraph role="tablecontent" id="par_id3148580" xml-lang="en-US" l10n="U" oldref="38">Greater than</paragraph> 168</tablecell> 169<tablecell colspan="" rowspan=""> 170<paragraph role="tablecontent" id="par_id3145138" xml-lang="en-US" l10n="U" oldref="39">A1>B1</paragraph> 171</tablecell> 172</tablerow> 173<tablerow> 174<tablecell colspan="" rowspan=""> 175<paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US" l10n="U" oldref="40">< (Less than)</paragraph> 176</tablecell> 177<tablecell colspan="" rowspan=""> 178<paragraph role="tablecontent" id="par_id3150145" xml-lang="en-US" l10n="U" oldref="41">Less than</paragraph> 179</tablecell> 180<tablecell colspan="" rowspan=""> 181<paragraph role="tablecontent" id="par_id3150901" xml-lang="en-US" l10n="U" oldref="42">A1<B1</paragraph> 182</tablecell> 183</tablerow> 184<tablerow> 185<tablecell colspan="" rowspan=""> 186<paragraph role="tablecontent" id="par_id3153078" xml-lang="en-US" l10n="U" oldref="43">>= (Greater than or equal to)</paragraph> 187</tablecell> 188<tablecell colspan="" rowspan=""> 189<paragraph role="tablecontent" id="par_id3150866" xml-lang="en-US" l10n="U" oldref="44">Greater than or equal to</paragraph> 190</tablecell> 191<tablecell colspan="" rowspan=""> 192<paragraph role="tablecontent" id="par_id3153111" xml-lang="en-US" l10n="U" oldref="45">A1>=B1</paragraph> 193</tablecell> 194</tablerow> 195<tablerow> 196<tablecell colspan="" rowspan=""> 197<paragraph role="tablecontent" id="par_id3153004" xml-lang="en-US" l10n="U" oldref="46"><= (Less than or equal to)</paragraph> 198</tablecell> 199<tablecell colspan="" rowspan=""> 200<paragraph role="tablecontent" id="par_id3150335" xml-lang="en-US" l10n="U" oldref="47">Less than or equal to</paragraph> 201</tablecell> 202<tablecell colspan="" rowspan=""> 203<paragraph role="tablecontent" id="par_id3148760" xml-lang="en-US" l10n="U" oldref="48">A1<=B1</paragraph> 204</tablecell> 205</tablerow> 206<tablerow> 207<tablecell colspan="" rowspan=""> 208<paragraph role="tablecontent" id="par_id3157994" xml-lang="en-US" l10n="U" oldref="49"><> (Inequality)</paragraph> 209</tablecell> 210<tablecell colspan="" rowspan=""> 211<paragraph role="tablecontent" id="par_id3150019" xml-lang="en-US" l10n="U" oldref="50">Inequality</paragraph> 212</tablecell> 213<tablecell colspan="" rowspan=""> 214<paragraph role="tablecontent" id="par_id3149878" xml-lang="en-US" l10n="U" oldref="51">A1<>B1</paragraph> 215</tablecell> 216</tablerow> 217</table> 218<paragraph role="heading" id="hd_id3145241" xml-lang="en-US" level="2" l10n="U" oldref="52">Text operators</paragraph> 219<paragraph role="paragraph" id="par_id3155438" xml-lang="en-US" l10n="U" oldref="53">The operator combines separate texts into one text.</paragraph> 220<table id="tbl_id3156061"> 221<tablerow> 222<tablecell colspan="" rowspan=""> 223<paragraph role="tablehead" id="par_id3150566" xml-lang="en-US" l10n="U" oldref="54">Operator</paragraph> 224</tablecell> 225<tablecell colspan="" rowspan=""> 226<paragraph role="tablehead" id="par_id3153048" xml-lang="en-US" l10n="U" oldref="55">Name</paragraph> 227</tablecell> 228<tablecell colspan="" rowspan=""> 229<paragraph role="tablehead" id="par_id3149001" xml-lang="en-US" l10n="U" oldref="56">Example</paragraph> 230</tablecell> 231</tablerow> 232<tablerow> 233<tablecell colspan="" rowspan=""> 234<paragraph role="tablecontent" id="par_id3148769" xml-lang="en-US" l10n="U" oldref="57">& (And)</paragraph> 235</tablecell> 236<tablecell colspan="" rowspan=""> 237<bookmark xml-lang="en-US" branch="index" id="bm_id3157975"><bookmark_value>text concatenation AND</bookmark_value> 238</bookmark> 239<paragraph role="tablecontent" id="par_id3157975" xml-lang="en-US" l10n="U" oldref="58">text concatenation AND</paragraph> 240</tablecell> 241<tablecell colspan="" rowspan=""> 242<paragraph role="tablecontent" id="par_id3157993" xml-lang="en-US" l10n="U" oldref="59">"Sun" & "day" is "Sunday"</paragraph> 243</tablecell> 244</tablerow> 245</table> 246<paragraph role="heading" id="hd_id3153550" xml-lang="en-US" level="2" l10n="U" oldref="60">Reference operators</paragraph> 247<paragraph role="paragraph" id="par_id3149024" xml-lang="en-US" l10n="CHG" oldref="61">These operators return a cell range of zero, one or more cells.</paragraph> 248<paragraph role="paragraph" id="par_id2324900" xml-lang="en-US" l10n="NEW">Range has the highest precedence, then intersection, and then finally union.</paragraph> 249<table id="tbl_id3154633"> 250<tablerow> 251<tablecell colspan="" rowspan=""> 252<paragraph role="tablehead" id="par_id3158416" xml-lang="en-US" l10n="U" oldref="62">Operator</paragraph> 253</tablecell> 254<tablecell colspan="" rowspan=""> 255<paragraph role="tablehead" id="par_id3152822" xml-lang="en-US" l10n="U" oldref="63">Name</paragraph> 256</tablecell> 257<tablecell colspan="" rowspan=""> 258<paragraph role="tablehead" id="par_id3154949" xml-lang="en-US" l10n="U" oldref="64">Example</paragraph> 259</tablecell> 260</tablerow> 261<tablerow> 262<tablecell colspan="" rowspan=""> 263<paragraph role="tablecontent" id="par_id3156257" xml-lang="en-US" l10n="U" oldref="65">: (Colon)</paragraph> 264</tablecell> 265<tablecell colspan="" rowspan=""> 266<paragraph role="tablecontent" id="par_id3153924" xml-lang="en-US" l10n="U" oldref="66">Range</paragraph> 267</tablecell> 268<tablecell colspan="" rowspan=""> 269<paragraph role="tablecontent" id="par_id3148432" xml-lang="en-US" l10n="U" oldref="67">A1:C108</paragraph> 270</tablecell> 271</tablerow> 272<tablerow> 273<tablecell colspan="" rowspan=""> 274<paragraph role="tablecontent" id="par_id3152592" xml-lang="en-US" l10n="U" oldref="68">! (Exclamation point)</paragraph> 275</tablecell> 276<tablecell colspan="" rowspan=""> 277<bookmark xml-lang="en-US" branch="index" id="bm_id3150606"><bookmark_value>intersection operator</bookmark_value> 278</bookmark> 279<paragraph role="tablecontent" id="par_id3150606" xml-lang="en-US" l10n="U" oldref="69">Intersection</paragraph> 280</tablecell> 281<tablecell colspan="" rowspan=""> 282<paragraph role="tablecontent" id="par_id3083445" xml-lang="en-US" l10n="U" oldref="70">SUM(A1:B6!B5:C12)</paragraph> 283<paragraph role="tablecontent" id="par_id3150385" xml-lang="en-US" l10n="U" oldref="71">Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6.</paragraph> 284</tablecell> 285</tablerow> 286<tablerow> 287<tablecell colspan="" rowspan=""> 288<paragraph role="tablecontent" id="par_id4003723" xml-lang="en-US" l10n="NEW">~ (Tilde)</paragraph> 289</tablecell> 290<tablecell colspan="" rowspan=""> 291<paragraph role="tablecontent" id="par_id838953" xml-lang="en-US" l10n="NEW">Concatenation or union</paragraph> 292</tablecell> 293<tablecell colspan="" rowspan=""> 294<paragraph role="tablecontent" id="par_id2511978" xml-lang="en-US" l10n="NEW">Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice. See note below this table.</paragraph> 295</tablecell> 296</tablerow> 297</table> 298<paragraph role="note" id="par_id181890" xml-lang="en-US" l10n="NEW">Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.</paragraph> 299</body> 300</helpdocument> 301