diff options
| -rw-r--r-- | source/text/scalc/01/04060199.xhp | 140 |
1 files changed, 70 insertions, 70 deletions
diff --git a/source/text/scalc/01/04060199.xhp b/source/text/scalc/01/04060199.xhp index 2f0be70c8a..d7c050fb11 100644 --- a/source/text/scalc/01/04060199.xhp +++ b/source/text/scalc/01/04060199.xhp @@ -19,12 +19,12 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc0104060199xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Operators in $[officename] Calc</title> +<title id="tit">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 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> @@ -35,16 +35,16 @@ <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> +<paragraph role="paragraph" id="par_id3155812">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> +<paragraph role="paragraph" id="par_id3148601">These operators return numerical results.</paragraph> <table id="tbl_id3151240"> <tablerow> <tablecell> -<paragraph role="tablehead" id="par_id3144768" xml-lang="en-US">Operator</paragraph> +<paragraph role="tablehead" id="par_id3144768">Operator</paragraph> </tablecell> <tablecell> -<paragraph role="tablehead" id="par_id3157982" xml-lang="en-US">Name</paragraph> +<paragraph role="tablehead" id="par_id3157982">Name</paragraph> </tablecell> <tablecell> <paragraph role="tablehead" id="par_id401599494815994">Example</paragraph> @@ -52,79 +52,79 @@ </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3149126" xml-lang="en-US">+ (Plus)</paragraph> +<paragraph role="tablecontent" id="par_id3149126">+ (Plus)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150892" xml-lang="en-US">Addition</paragraph> +<paragraph role="tablecontent" id="par_id3150892">Addition</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3153247" localize="false" xml-lang="en-US">1+1</paragraph> +<paragraph role="tablecontent" id="par_id3153247" localize="false">1+1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3159204" xml-lang="en-US">- (Minus)</paragraph> +<paragraph role="tablecontent" id="par_id3159204">- (Minus)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3145362" xml-lang="en-US">Subtraction</paragraph> +<paragraph role="tablecontent" id="par_id3145362">Subtraction</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3153554" localize="false" xml-lang="en-US">2-1</paragraph> +<paragraph role="tablecontent" id="par_id3153554" localize="false">2-1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3153808" xml-lang="en-US">- (Minus)</paragraph> +<paragraph role="tablecontent" id="par_id3153808">- (Minus)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3151193" xml-lang="en-US">Negation</paragraph> +<paragraph role="tablecontent" id="par_id3151193">Negation</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3154712" localize="false" xml-lang="en-US">-5</paragraph> +<paragraph role="tablecontent" id="par_id3154712" localize="false">-5</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3149873" xml-lang="en-US">* (asterisk)</paragraph> +<paragraph role="tablecontent" id="par_id3149873">* (asterisk)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3147504" xml-lang="en-US">Multiplication</paragraph> +<paragraph role="tablecontent" id="par_id3147504">Multiplication</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3149055" localize="false" xml-lang="en-US">2*2</paragraph> +<paragraph role="tablecontent" id="par_id3149055" localize="false">2*2</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3151341" xml-lang="en-US">/ (Slash)</paragraph> +<paragraph role="tablecontent" id="par_id3151341">/ (Slash)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3159260" xml-lang="en-US">Division</paragraph> +<paragraph role="tablecontent" id="par_id3159260">Division</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3153027" localize="false" xml-lang="en-US">9/3</paragraph> +<paragraph role="tablecontent" id="par_id3153027" localize="false">9/3</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3156396" xml-lang="en-US">% (Percent)</paragraph> +<paragraph role="tablecontent" id="par_id3156396">% (Percent)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150372" xml-lang="en-US">Percent</paragraph> +<paragraph role="tablecontent" id="par_id3150372">Percent</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3145632" localize="false" xml-lang="en-US">15%</paragraph> +<paragraph role="tablecontent" id="par_id3145632" localize="false">15%</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3149722" xml-lang="en-US">^ (Caret)</paragraph> +<paragraph role="tablecontent" id="par_id3149722">^ (Caret)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3159127" xml-lang="en-US">Exponentiation</paragraph> +<paragraph role="tablecontent" id="par_id3159127">Exponentiation</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3157873" localize="false" xml-lang="en-US">3^2</paragraph> +<paragraph role="tablecontent" id="par_id3157873" localize="false">3^2</paragraph> </tablecell> </tablerow> </table> @@ -132,14 +132,14 @@ <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> +<paragraph role="paragraph" id="par_id3157902">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> +<paragraph role="tablehead" id="par_id3149889">Operator</paragraph> </tablecell> <tablecell> -<paragraph role="tablehead" id="par_id3150743" xml-lang="en-US">Name</paragraph> +<paragraph role="tablehead" id="par_id3150743">Name</paragraph> </tablecell> <tablecell> <paragraph role="tablehead" id="par_id201599495083374">Example</paragraph> @@ -147,80 +147,80 @@ </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3148888" xml-lang="en-US">= (equal sign)</paragraph> +<paragraph role="tablecontent" id="par_id3148888">= (equal sign)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3154845" xml-lang="en-US">Equal</paragraph> +<paragraph role="tablecontent" id="par_id3154845">Equal</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3154546" localize="false" xml-lang="en-US">A1=B1</paragraph> +<paragraph role="tablecontent" id="par_id3154546" localize="false">A1=B1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3154807" xml-lang="en-US">> (Greater than)</paragraph> +<paragraph role="tablecontent" id="par_id3154807">> (Greater than)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3148580" xml-lang="en-US">Greater than</paragraph> +<paragraph role="tablecontent" id="par_id3148580">Greater than</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3145138" localize="false" xml-lang="en-US">A1>B1</paragraph> +<paragraph role="tablecontent" id="par_id3145138" localize="false">A1>B1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US">< (Less than)</paragraph> +<paragraph role="tablecontent" id="par_id3149507">< (Less than)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150145" xml-lang="en-US">Less than</paragraph> +<paragraph role="tablecontent" id="par_id3150145">Less than</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150901" localize="false" xml-lang="en-US">A1<B1</paragraph> +<paragraph role="tablecontent" id="par_id3150901" localize="false">A1<B1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3153078" xml-lang="en-US">>= (Greater than or equal to)</paragraph> +<paragraph role="tablecontent" id="par_id3153078">>= (Greater than or equal to)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150866" xml-lang="en-US">Greater than or equal to</paragraph> +<paragraph role="tablecontent" id="par_id3150866">Greater than or equal to</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3153111" localize="false" xml-lang="en-US">A1>=B1</paragraph> +<paragraph role="tablecontent" id="par_id3153111" localize="false">A1>=B1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3153004" xml-lang="en-US"><= (Less than or equal to)</paragraph> +<paragraph role="tablecontent" id="par_id3153004"><= (Less than or equal to)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150335" xml-lang="en-US">Less than or equal to</paragraph> +<paragraph role="tablecontent" id="par_id3150335">Less than or equal to</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3148760" localize="false" xml-lang="en-US">A1<=B1</paragraph> +<paragraph role="tablecontent" id="par_id3148760" localize="false">A1<=B1</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3157994" xml-lang="en-US"><> (Inequality)</paragraph> +<paragraph role="tablecontent" id="par_id3157994"><> (Inequality)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3150019" xml-lang="en-US">Inequality</paragraph> +<paragraph role="tablecontent" id="par_id3150019">Inequality</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3149878" localize="false" xml-lang="en-US">A1<>B1</paragraph> +<paragraph role="tablecontent" id="par_id3149878" localize="false">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> +<paragraph role="paragraph" id="par_id3155438">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> +<paragraph role="tablehead" id="par_id3150566">Operator</paragraph> </tablecell> <tablecell> -<paragraph role="tablehead" id="par_id3153048" xml-lang="en-US">Name</paragraph> +<paragraph role="tablehead" id="par_id3153048">Name</paragraph> </tablecell> <tablecell> <paragraph role="tablehead" id="par_id201599494708332">Example</paragraph> @@ -228,29 +228,29 @@ </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3148769" xml-lang="en-US">& (And)</paragraph> +<paragraph role="tablecontent" id="par_id3148769">& (And)</paragraph> </tablecell> <tablecell> -<bookmark xml-lang="en-US" branch="index" id="bm_id3157975"><bookmark_value>text concatenation AND</bookmark_value> +<bookmark 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> +<paragraph role="tablecontent" id="par_id3157975">text concatenation AND</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3157993" xml-lang="en-US">"Sun" & "day" is "Sunday"</paragraph> +<paragraph role="tablecontent" id="par_id3157993">"Sun" & "day" is "Sunday"</paragraph> </tablecell> </tablerow> </table> <section id="referenceoperators"> <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> +<paragraph role="paragraph" id="par_id3149024">These operators return a cell range of zero, one or more cells.</paragraph> +<paragraph role="paragraph" id="par_id2324900">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> +<paragraph role="tablehead" id="par_id3158416">Operator</paragraph> </tablecell> <tablecell> -<paragraph role="tablehead" id="par_id3152822" xml-lang="en-US">Name</paragraph> +<paragraph role="tablehead" id="par_id3152822">Name</paragraph> </tablecell> <tablecell> <paragraph role="tablehead" id="par_id521599494740206">Example</paragraph> @@ -258,38 +258,38 @@ </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3156257" xml-lang="en-US">: (Colon)</paragraph> +<paragraph role="tablecontent" id="par_id3156257">: (Colon)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3153924" xml-lang="en-US">Range</paragraph> +<paragraph role="tablecontent" id="par_id3153924">Range</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id3148432" xml-lang="en-US">A1:C108, A:D or 3:13</paragraph> +<paragraph role="tablecontent" id="par_id3148432">A1:C108, A:D or 3:13</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> -<paragraph role="tablecontent" id="par_id3152592" xml-lang="en-US">! (Exclamation point)</paragraph> +<paragraph role="tablecontent" id="par_id3152592">! (Exclamation point)</paragraph> </tablecell> <tablecell> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150606"><bookmark_value>intersection operator</bookmark_value> +<bookmark branch="index" id="bm_id3150606"><bookmark_value>intersection operator</bookmark_value> </bookmark> -<paragraph role="tablecontent" id="par_id3150606" xml-lang="en-US">Intersection</paragraph> +<paragraph role="tablecontent" id="par_id3150606">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> +<paragraph role="tablecontent" id="par_id3083445">SUM(A1:B6!B5:C12)</paragraph> +<paragraph role="tablecontent" id="par_id3150385">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> +<paragraph role="tablecontent" id="par_id4003723">~ (Tilde)</paragraph> </tablecell> <tablecell> -<paragraph role="tablecontent" id="par_id838953" xml-lang="en-US">Concatenation or union</paragraph> +<paragraph role="tablecontent" id="par_id838953">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.</paragraph> +<paragraph role="tablecontent" id="par_id2511978">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.</paragraph> <paragraph role="paragraph" id="par_id961672071835372"><input>=COUNT(A1:B2~B2:C3)</input> counts values of A1:B2 and B2:C3. Note that the cell B2 is counted twice.</paragraph> <paragraph role="paragraph" id="par_id401672243346224"><input>=INDEX(A1:B2~C1:D2;2;1;2)</input> selects cell C2, that is, the first cell of the second row, first column, of the second range (C1:D2) of the range list.</paragraph> </tablecell> |