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