1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 352ac0773SAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 552ac0773SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 652ac0773SAndrew Rist * or more contributor license agreements. See the NOTICE file 752ac0773SAndrew Rist * distributed with this work for additional information 852ac0773SAndrew Rist * regarding copyright ownership. The ASF licenses this file 952ac0773SAndrew Rist * to you under the Apache License, Version 2.0 (the 1052ac0773SAndrew Rist * "License"); you may not use this file except in compliance 1152ac0773SAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 1352ac0773SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 1552ac0773SAndrew Rist * Unless required by applicable law or agreed to in writing, 1652ac0773SAndrew Rist * software distributed under the License is distributed on an 1752ac0773SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1852ac0773SAndrew Rist * KIND, either express or implied. See the License for the 1952ac0773SAndrew Rist * specific language governing permissions and limitations 2052ac0773SAndrew Rist * under the License. 21cdf0e10cSrcweir * 2252ac0773SAndrew Rist ***********************************************************--> 2352ac0773SAndrew Rist 24cdf0e10cSrcweir<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0104060199xml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Operators in $[officename] Calc</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/04060199.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32c5ffc49bSmseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3156445"> 33c5ffc49bSmseidel<bookmark_value>formulas; operators</bookmark_value> 34cdf0e10cSrcweir<bookmark_value>operators; formula functions</bookmark_value> 35cdf0e10cSrcweir<bookmark_value>division sign, see also operators</bookmark_value> 36cdf0e10cSrcweir<bookmark_value>multiplication sign, see also operators</bookmark_value> 37cdf0e10cSrcweir<bookmark_value>minus sign, see also operators</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>plus sign, see also operators</bookmark_value> 39cdf0e10cSrcweir<bookmark_value>text operators</bookmark_value> 40cdf0e10cSrcweir<bookmark_value>comparisons;operators in Calc</bookmark_value> 41cdf0e10cSrcweir<bookmark_value>arithmetical operators</bookmark_value> 42cdf0e10cSrcweir<bookmark_value>reference operators</bookmark_value> 4388cae784Smseidel</bookmark><comment>mw added 7 new index entries</comment> 44*d5240548Smseidel<paragraph role="heading" id="hd_id3156445" xml-lang="en-US" level="1" l10n="U">Operators in $[officename] Calc</paragraph> 45*d5240548Smseidel<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US" l10n="U">You can use the following operators in $[officename] Calc:</paragraph> 46*d5240548Smseidel<paragraph role="heading" id="hd_id3153066" xml-lang="en-US" level="2" l10n="U">Arithmetical Operators</paragraph> 47*d5240548Smseidel<paragraph role="paragraph" id="par_id3148601" xml-lang="en-US" l10n="U">These operators return numerical results.</paragraph> 48cdf0e10cSrcweir<table id="tbl_id3151240"> 49cdf0e10cSrcweir<tablerow> 50cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 51*d5240548Smseidel<paragraph role="tablehead" id="par_id3144768" xml-lang="en-US" l10n="U">Operator</paragraph> 52cdf0e10cSrcweir</tablecell> 53cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 54*d5240548Smseidel<paragraph role="tablehead" id="par_id3157982" xml-lang="en-US" l10n="U">Name</paragraph> 55cdf0e10cSrcweir</tablecell> 56cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 57*d5240548Smseidel<paragraph role="tablehead" id="par_id3159096" xml-lang="en-US" l10n="U">Example</paragraph> 58cdf0e10cSrcweir</tablecell> 59cdf0e10cSrcweir</tablerow> 60cdf0e10cSrcweir<tablerow> 61cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 62*d5240548Smseidel<paragraph role="tablecontent" id="par_id3149126" xml-lang="en-US" l10n="U">+ (Plus)</paragraph> 63cdf0e10cSrcweir</tablecell> 64cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 65*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150892" xml-lang="en-US" l10n="U">Addition</paragraph> 66cdf0e10cSrcweir</tablecell> 67cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 68*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153247" xml-lang="en-US" l10n="U">1+1</paragraph> 69cdf0e10cSrcweir</tablecell> 70cdf0e10cSrcweir</tablerow> 71cdf0e10cSrcweir<tablerow> 72cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 73*d5240548Smseidel<paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US" l10n="U">- (Minus)</paragraph> 74cdf0e10cSrcweir</tablecell> 75cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 76*d5240548Smseidel<paragraph role="tablecontent" id="par_id3145362" xml-lang="en-US" l10n="U">Subtraction</paragraph> 77cdf0e10cSrcweir</tablecell> 78cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 79*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153554" xml-lang="en-US" l10n="U">2-1</paragraph> 80cdf0e10cSrcweir</tablecell> 81cdf0e10cSrcweir</tablerow> 82cdf0e10cSrcweir<tablerow> 83cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 84*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153808" xml-lang="en-US" l10n="U">- (Minus)</paragraph> 85cdf0e10cSrcweir</tablecell> 86cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 87*d5240548Smseidel<paragraph role="tablecontent" id="par_id3151193" xml-lang="en-US" l10n="U">Negation</paragraph> 88cdf0e10cSrcweir</tablecell> 89cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 90*d5240548Smseidel<paragraph role="tablecontent" id="par_id3154712" xml-lang="en-US" l10n="U">-5</paragraph> 91cdf0e10cSrcweir</tablecell> 92cdf0e10cSrcweir</tablerow> 93cdf0e10cSrcweir<tablerow> 94cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 95*d5240548Smseidel<paragraph role="tablecontent" id="par_id3149873" xml-lang="en-US" l10n="U">* (asterisk)</paragraph> 96cdf0e10cSrcweir</tablecell> 97cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 98*d5240548Smseidel<paragraph role="tablecontent" id="par_id3147504" xml-lang="en-US" l10n="U">Multiplication</paragraph> 99cdf0e10cSrcweir</tablecell> 100cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 101*d5240548Smseidel<paragraph role="tablecontent" id="par_id3149055" xml-lang="en-US" l10n="U">2*2</paragraph> 102cdf0e10cSrcweir</tablecell> 103cdf0e10cSrcweir</tablerow> 104cdf0e10cSrcweir<tablerow> 105cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 106*d5240548Smseidel<paragraph role="tablecontent" id="par_id3151341" xml-lang="en-US" l10n="U">/ (Slash)</paragraph> 107cdf0e10cSrcweir</tablecell> 108cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 109*d5240548Smseidel<paragraph role="tablecontent" id="par_id3159260" xml-lang="en-US" l10n="U">Division</paragraph> 110cdf0e10cSrcweir</tablecell> 111cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 112*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153027" xml-lang="en-US" l10n="U">9/3</paragraph> 113cdf0e10cSrcweir</tablecell> 114cdf0e10cSrcweir</tablerow> 115cdf0e10cSrcweir<tablerow> 116cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 117*d5240548Smseidel<paragraph role="tablecontent" id="par_id3156396" xml-lang="en-US" l10n="U">% (Percent)</paragraph> 118cdf0e10cSrcweir</tablecell> 119cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 120*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150372" xml-lang="en-US" l10n="U">Percent</paragraph> 121cdf0e10cSrcweir</tablecell> 122cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 123*d5240548Smseidel<paragraph role="tablecontent" id="par_id3145632" xml-lang="en-US" l10n="U">15%</paragraph> 124cdf0e10cSrcweir</tablecell> 125cdf0e10cSrcweir</tablerow> 126cdf0e10cSrcweir<tablerow> 127cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 128*d5240548Smseidel<paragraph role="tablecontent" id="par_id3149722" xml-lang="en-US" l10n="U">^ (Caret)</paragraph> 129cdf0e10cSrcweir</tablecell> 130cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 131*d5240548Smseidel<paragraph role="tablecontent" id="par_id3159127" xml-lang="en-US" l10n="U">Exponentiation</paragraph> 132cdf0e10cSrcweir</tablecell> 133cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 134*d5240548Smseidel<paragraph role="tablecontent" id="par_id3157873" xml-lang="en-US" l10n="U">3^2</paragraph> 135cdf0e10cSrcweir</tablecell> 136cdf0e10cSrcweir</tablerow> 137cdf0e10cSrcweir</table> 138*d5240548Smseidel<paragraph role="heading" id="hd_id3152981" xml-lang="en-US" level="2" l10n="U">Comparative operators</paragraph> 139*d5240548Smseidel<paragraph role="paragraph" id="par_id3157902" xml-lang="en-US" l10n="U">These operators return either true or false.</paragraph> 140cdf0e10cSrcweir<table id="tbl_id3148725"> 141cdf0e10cSrcweir<tablerow> 142cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 143*d5240548Smseidel<paragraph role="tablehead" id="par_id3149889" xml-lang="en-US" l10n="U">Operator</paragraph> 144cdf0e10cSrcweir</tablecell> 145cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 146*d5240548Smseidel<paragraph role="tablehead" id="par_id3150743" xml-lang="en-US" l10n="U">Name</paragraph> 147cdf0e10cSrcweir</tablecell> 148cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 149*d5240548Smseidel<paragraph role="tablehead" id="par_id3146877" xml-lang="en-US" l10n="U">Example</paragraph> 150cdf0e10cSrcweir</tablecell> 151cdf0e10cSrcweir</tablerow> 152cdf0e10cSrcweir<tablerow> 153cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 154*d5240548Smseidel<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US" l10n="U">= (equal sign)</paragraph> 155cdf0e10cSrcweir</tablecell> 156cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 157*d5240548Smseidel<paragraph role="tablecontent" id="par_id3154845" xml-lang="en-US" l10n="U">Equal</paragraph> 158cdf0e10cSrcweir</tablecell> 159cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 160*d5240548Smseidel<paragraph role="tablecontent" id="par_id3154546" xml-lang="en-US" l10n="U">A1=B1</paragraph> 161cdf0e10cSrcweir</tablecell> 162cdf0e10cSrcweir</tablerow> 163cdf0e10cSrcweir<tablerow> 164cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 165*d5240548Smseidel<paragraph role="tablecontent" id="par_id3154807" xml-lang="en-US" l10n="U">> (Greater than)</paragraph> 166cdf0e10cSrcweir</tablecell> 167cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 168*d5240548Smseidel<paragraph role="tablecontent" id="par_id3148580" xml-lang="en-US" l10n="U">Greater than</paragraph> 169cdf0e10cSrcweir</tablecell> 170cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 171*d5240548Smseidel<paragraph role="tablecontent" id="par_id3145138" xml-lang="en-US" l10n="U">A1>B1</paragraph> 172cdf0e10cSrcweir</tablecell> 173cdf0e10cSrcweir</tablerow> 174cdf0e10cSrcweir<tablerow> 175cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 176*d5240548Smseidel<paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US" l10n="U">< (Less than)</paragraph> 177cdf0e10cSrcweir</tablecell> 178cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 179*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150145" xml-lang="en-US" l10n="U">Less than</paragraph> 180cdf0e10cSrcweir</tablecell> 181cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 182*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150901" xml-lang="en-US" l10n="U">A1<B1</paragraph> 183cdf0e10cSrcweir</tablecell> 184cdf0e10cSrcweir</tablerow> 185cdf0e10cSrcweir<tablerow> 186cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 187*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153078" xml-lang="en-US" l10n="U">>= (Greater than or equal to)</paragraph> 188cdf0e10cSrcweir</tablecell> 189cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 190*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150866" xml-lang="en-US" l10n="U">Greater than or equal to</paragraph> 191cdf0e10cSrcweir</tablecell> 192cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 193*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153111" xml-lang="en-US" l10n="U">A1>=B1</paragraph> 194cdf0e10cSrcweir</tablecell> 195cdf0e10cSrcweir</tablerow> 196cdf0e10cSrcweir<tablerow> 197cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 198*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153004" xml-lang="en-US" l10n="U"><= (Less than or equal to)</paragraph> 199cdf0e10cSrcweir</tablecell> 200cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 201*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150335" xml-lang="en-US" l10n="U">Less than or equal to</paragraph> 202cdf0e10cSrcweir</tablecell> 203cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 204*d5240548Smseidel<paragraph role="tablecontent" id="par_id3148760" xml-lang="en-US" l10n="U">A1<=B1</paragraph> 205cdf0e10cSrcweir</tablecell> 206cdf0e10cSrcweir</tablerow> 207cdf0e10cSrcweir<tablerow> 208cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 209*d5240548Smseidel<paragraph role="tablecontent" id="par_id3157994" xml-lang="en-US" l10n="U"><> (Inequality)</paragraph> 210cdf0e10cSrcweir</tablecell> 211cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 212*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150019" xml-lang="en-US" l10n="U">Inequality</paragraph> 213cdf0e10cSrcweir</tablecell> 214cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 215*d5240548Smseidel<paragraph role="tablecontent" id="par_id3149878" xml-lang="en-US" l10n="U">A1<>B1</paragraph> 216cdf0e10cSrcweir</tablecell> 217cdf0e10cSrcweir</tablerow> 218cdf0e10cSrcweir</table> 219*d5240548Smseidel<paragraph role="heading" id="hd_id3145241" xml-lang="en-US" level="2" l10n="U">Text operators</paragraph> 220*d5240548Smseidel<paragraph role="paragraph" id="par_id3155438" xml-lang="en-US" l10n="U">The operator combines separate texts into one text.</paragraph> 221cdf0e10cSrcweir<table id="tbl_id3156061"> 222cdf0e10cSrcweir<tablerow> 223cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 224*d5240548Smseidel<paragraph role="tablehead" id="par_id3150566" xml-lang="en-US" l10n="U">Operator</paragraph> 225cdf0e10cSrcweir</tablecell> 226cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 227*d5240548Smseidel<paragraph role="tablehead" id="par_id3153048" xml-lang="en-US" l10n="U">Name</paragraph> 228cdf0e10cSrcweir</tablecell> 229cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 230*d5240548Smseidel<paragraph role="tablehead" id="par_id3149001" xml-lang="en-US" l10n="U">Example</paragraph> 231cdf0e10cSrcweir</tablecell> 232cdf0e10cSrcweir</tablerow> 233cdf0e10cSrcweir<tablerow> 234cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 235*d5240548Smseidel<paragraph role="tablecontent" id="par_id3148769" xml-lang="en-US" l10n="U">& (And)</paragraph> 236cdf0e10cSrcweir</tablecell> 237cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 23888cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3157975"> 23988cae784Smseidel<bookmark_value>text concatenation AND</bookmark_value> 240cdf0e10cSrcweir</bookmark> 241*d5240548Smseidel<paragraph role="tablecontent" id="par_id3157975" xml-lang="en-US" l10n="U">text concatenation AND</paragraph> 242cdf0e10cSrcweir</tablecell> 243cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 244*d5240548Smseidel<paragraph role="tablecontent" id="par_id3157993" xml-lang="en-US" l10n="U">"Sun" & "day" is "Sunday"</paragraph> 245cdf0e10cSrcweir</tablecell> 246cdf0e10cSrcweir</tablerow> 247cdf0e10cSrcweir</table> 248*d5240548Smseidel<paragraph role="heading" id="hd_id3153550" xml-lang="en-US" level="2" l10n="U">Reference operators</paragraph> 249*d5240548Smseidel<paragraph role="paragraph" id="par_id3149024" xml-lang="en-US" l10n="CHG">These operators return a cell range of zero, one or more cells.</paragraph> 250cdf0e10cSrcweir<paragraph role="paragraph" id="par_id2324900" xml-lang="en-US" l10n="NEW">Range has the highest precedence, then intersection, and then finally union.</paragraph> 251cdf0e10cSrcweir<table id="tbl_id3154633"> 252cdf0e10cSrcweir<tablerow> 253cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 254*d5240548Smseidel<paragraph role="tablehead" id="par_id3158416" xml-lang="en-US" l10n="U">Operator</paragraph> 255cdf0e10cSrcweir</tablecell> 256cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 257*d5240548Smseidel<paragraph role="tablehead" id="par_id3152822" xml-lang="en-US" l10n="U">Name</paragraph> 258cdf0e10cSrcweir</tablecell> 259cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 260*d5240548Smseidel<paragraph role="tablehead" id="par_id3154949" xml-lang="en-US" l10n="U">Example</paragraph> 261cdf0e10cSrcweir</tablecell> 262cdf0e10cSrcweir</tablerow> 263cdf0e10cSrcweir<tablerow> 264cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 265*d5240548Smseidel<paragraph role="tablecontent" id="par_id3156257" xml-lang="en-US" l10n="U">: (Colon)</paragraph> 266cdf0e10cSrcweir</tablecell> 267cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 268*d5240548Smseidel<paragraph role="tablecontent" id="par_id3153924" xml-lang="en-US" l10n="U">Range</paragraph> 269cdf0e10cSrcweir</tablecell> 270cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 271*d5240548Smseidel<paragraph role="tablecontent" id="par_id3148432" xml-lang="en-US" l10n="U">A1:C108</paragraph> 272cdf0e10cSrcweir</tablecell> 273cdf0e10cSrcweir</tablerow> 274cdf0e10cSrcweir<tablerow> 275cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 276*d5240548Smseidel<paragraph role="tablecontent" id="par_id3152592" xml-lang="en-US" l10n="U">! (Exclamation point)</paragraph> 277cdf0e10cSrcweir</tablecell> 278cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 27988cae784Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3150606"> 28088cae784Smseidel<bookmark_value>intersection operator</bookmark_value> 281cdf0e10cSrcweir</bookmark> 282*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150606" xml-lang="en-US" l10n="U">Intersection</paragraph> 283cdf0e10cSrcweir</tablecell> 284cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 285*d5240548Smseidel<paragraph role="tablecontent" id="par_id3083445" xml-lang="en-US" l10n="U">SUM(A1:B6!B5:C12)</paragraph> 286*d5240548Smseidel<paragraph role="tablecontent" id="par_id3150385" xml-lang="en-US" l10n="U">Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6.</paragraph> 287cdf0e10cSrcweir</tablecell> 288cdf0e10cSrcweir</tablerow> 289cdf0e10cSrcweir<tablerow> 290cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 291cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id4003723" xml-lang="en-US" l10n="NEW">~ (Tilde)</paragraph> 292cdf0e10cSrcweir</tablecell> 293cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 294cdf0e10cSrcweir<paragraph role="tablecontent" id="par_id838953" xml-lang="en-US" l10n="NEW">Concatenation or union</paragraph> 295cdf0e10cSrcweir</tablecell> 296cdf0e10cSrcweir<tablecell colspan="" rowspan=""> 297cdf0e10cSrcweir<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> 298cdf0e10cSrcweir</tablecell> 299cdf0e10cSrcweir</tablerow> 300cdf0e10cSrcweir</table> 301cdf0e10cSrcweir<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> 302cdf0e10cSrcweir</body> 303cdf0e10cSrcweir</helpdocument> 304