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