helpcontent2/source/text/scalc/01/04060199.xhp

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