diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060199.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060199.xhp | 297 |
1 files changed, 297 insertions, 0 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060199.xhp b/helpcontent2/source/text/scalc/01/04060199.xhp new file mode 100644 index 000000000..b30def43f --- /dev/null +++ b/helpcontent2/source/text/scalc/01/04060199.xhp @@ -0,0 +1,297 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> +<helpdocument version="1.0"> +<meta> +<topic id="textscalc0104060199xml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Operators in $[officename] Calc</title> +<filename>/text/scalc/01/04060199.xhp</filename> +</topic> +</meta> +<body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156445"><bookmark_value>formulas; operators</bookmark_value> +<bookmark_value>operators; formula functions</bookmark_value> +<bookmark_value>division sign, see also operators</bookmark_value> +<bookmark_value>multiplication sign, see also operators</bookmark_value> +<bookmark_value>minus sign, see also operators</bookmark_value> +<bookmark_value>plus sign, see also operators</bookmark_value> +<bookmark_value>text operators</bookmark_value> +<bookmark_value>comparisons;operators in Calc</bookmark_value> +<bookmark_value>arithmetical operators</bookmark_value> +<bookmark_value>reference operators</bookmark_value> +</bookmark><comment>mw added 7 new index entries</comment><h1 id="hd_id3156445">Operators in $[officename] Calc</h1> +<paragraph role="paragraph" id="par_id3155812" xml-lang="en-US">You can use the following operators in $[officename] Calc:</paragraph> +<h2 id="hd_id3153066">Arithmetical Operators</h2> +<paragraph role="paragraph" id="par_id3148601" xml-lang="en-US">These operators return numerical results.</paragraph> +<table id="tbl_id3151240"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3144768" xml-lang="en-US">Operator</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3157982" xml-lang="en-US">Name</paragraph> +</tablecell> +<tablecell> + <paragraph role="tablehead" id="par_id401599494815994">Example</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149126" xml-lang="en-US">+ (Plus)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150892" xml-lang="en-US">Addition</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3153247" localize="false" xml-lang="en-US">1+1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US">- (Minus)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3145362" xml-lang="en-US">Subtraction</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3153554" localize="false" xml-lang="en-US">2-1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3153808" xml-lang="en-US">- (Minus)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3151193" xml-lang="en-US">Negation</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3154712" localize="false" xml-lang="en-US">-5</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149873" xml-lang="en-US">* (asterisk)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3147504" xml-lang="en-US">Multiplication</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3149055" localize="false" xml-lang="en-US">2*2</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3151341" xml-lang="en-US">/ (Slash)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3159260" xml-lang="en-US">Division</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3153027" localize="false" xml-lang="en-US">9/3</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3156396" xml-lang="en-US">% (Percent)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150372" xml-lang="en-US">Percent</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3145632" localize="false" xml-lang="en-US">15%</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149722" xml-lang="en-US">^ (Caret)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3159127" xml-lang="en-US">Exponentiation</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3157873" localize="false" xml-lang="en-US">3^2</paragraph> +</tablecell> +</tablerow> +</table> + +<note id="par_id881623862728559">Prefix "-" (negation) has a higher precedence than "^" (exponentiation). For example -3^2 equals 9, which is the square of a negative number.</note> + +<h2 id="hd_id3152981">Comparative operators</h2> +<paragraph role="paragraph" id="par_id3157902" xml-lang="en-US">These operators return either true or false.</paragraph> +<table id="tbl_id3148725"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3149889" xml-lang="en-US">Operator</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3150743" xml-lang="en-US">Name</paragraph> +</tablecell> +<tablecell> + <paragraph role="tablehead" id="par_id201599495083374">Example</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US">= (equal sign)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3154845" xml-lang="en-US">Equal</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3154546" localize="false" xml-lang="en-US">A1=B1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3154807" xml-lang="en-US">> (Greater than)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3148580" xml-lang="en-US">Greater than</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3145138" localize="false" xml-lang="en-US">A1>B1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US">< (Less than)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150145" xml-lang="en-US">Less than</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150901" localize="false" xml-lang="en-US">A1<B1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3153078" xml-lang="en-US">>= (Greater than or equal to)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150866" xml-lang="en-US">Greater than or equal to</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3153111" localize="false" xml-lang="en-US">A1>=B1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3153004" xml-lang="en-US"><= (Less than or equal to)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150335" xml-lang="en-US">Less than or equal to</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3148760" localize="false" xml-lang="en-US">A1<=B1</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3157994" xml-lang="en-US"><> (Inequality)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150019" xml-lang="en-US">Inequality</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3149878" localize="false" xml-lang="en-US">A1<>B1</paragraph> +</tablecell> +</tablerow> +</table> +<h2 id="hd_id3145241">Text operators</h2> +<paragraph role="paragraph" id="par_id3155438" xml-lang="en-US">The operator combines separate texts into one text.</paragraph> +<table id="tbl_id3156061"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3150566" xml-lang="en-US">Operator</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3153048" xml-lang="en-US">Name</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id201599494708332">Example</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3148769" xml-lang="en-US">& (And)</paragraph> +</tablecell> +<tablecell> +<bookmark xml-lang="en-US" branch="index" id="bm_id3157975"><bookmark_value>text concatenation AND</bookmark_value> +</bookmark> +<paragraph role="tablecontent" id="par_id3157975" xml-lang="en-US">text concatenation AND</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3157993" xml-lang="en-US">"Sun" & "day" is "Sunday"</paragraph> +</tablecell> +</tablerow> +</table> +<h2 id="hd_id3153550">Reference operators</h2> +<paragraph role="paragraph" id="par_id3149024" xml-lang="en-US">These operators return a cell range of zero, one or more cells.</paragraph> +<paragraph role="paragraph" id="par_id2324900" xml-lang="en-US">Range has the highest precedence, then intersection, and then finally union.</paragraph> +<table id="tbl_id3154633"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3158416" xml-lang="en-US">Operator</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3152822" xml-lang="en-US">Name</paragraph> +</tablecell> +<tablecell> + <paragraph role="tablehead" id="par_id521599494740206">Example</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3156257" xml-lang="en-US">: (Colon)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3153924" xml-lang="en-US">Range</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3148432" localize="false" xml-lang="en-US">A1:C108</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3152592" xml-lang="en-US">! (Exclamation point)</paragraph> +</tablecell> +<tablecell> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150606"><bookmark_value>intersection operator</bookmark_value> +</bookmark> +<paragraph role="tablecontent" id="par_id3150606" xml-lang="en-US">Intersection</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3083445" xml-lang="en-US">SUM(A1:B6!B5:C12)</paragraph> +<paragraph role="tablecontent" id="par_id3150385" xml-lang="en-US">Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6.</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id4003723" xml-lang="en-US">~ (Tilde)</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id838953" xml-lang="en-US">Concatenation or union</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id2511978" xml-lang="en-US">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> +</tablecell> +</tablerow> +</table> +<note id="par_id181890">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.</note> +</body> +</helpdocument> |