From 691744afc91d923e2d7b165e1e675fb02c4fbd1f Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Fri, 23 Jun 2023 19:31:32 -0300 Subject: Refactor, no changes. Change-Id: I11d58e24520d749c30b73913555d478a24806cfc Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153541 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 5d7fd5dd8910f3d7bc98c8a3d452102d133f4ffa) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/153522 --- source/text/scalc/01/04060199.xhp | 140 +++++++++++++++++++------------------- 1 file changed, 70 insertions(+), 70 deletions(-) (limited to 'source') 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 @@ -Operators in $[officename] Calc +Operators in $[officename] Calc /text/scalc/01/04060199.xhp -formulas; operators +formulas; operators operators; formula functions division sign, see also operators multiplication sign, see also operators @@ -35,16 +35,16 @@ arithmetical operators reference operators mw added 7 new index entries

Operators in $[officename] Calc

-You can use the following operators in $[officename] Calc: +You can use the following operators in $[officename] Calc:

Arithmetical Operators

-These operators return numerical results. +These operators return numerical results. -Operator +Operator -Name +Name Example @@ -52,79 +52,79 @@ -+ (Plus) ++ (Plus) -Addition +Addition -1+1 +1+1 -- (Minus) +- (Minus) -Subtraction +Subtraction -2-1 +2-1 -- (Minus) +- (Minus) -Negation +Negation --5 +-5 -* (asterisk) +* (asterisk) -Multiplication +Multiplication -2*2 +2*2 -/ (Slash) +/ (Slash) -Division +Division -9/3 +9/3 -% (Percent) +% (Percent) -Percent +Percent -15% +15% -^ (Caret) +^ (Caret) -Exponentiation +Exponentiation -3^2 +3^2

@@ -132,14 +132,14 @@ Prefix "-" (negation) has a higher precedence than "^" (exponentiation). For example -3^2 equals 9, which is the square of a negative number.

Comparative operators

-These operators return either true or false. +These operators return either true or false. -Operator +Operator -Name +Name Example @@ -147,80 +147,80 @@ -= (equal sign) += (equal sign) -Equal +Equal -A1=B1 +A1=B1 -> (Greater than) +> (Greater than) -Greater than +Greater than -A1>B1 +A1>B1 -< (Less than) +< (Less than) -Less than +Less than -A1<B1 +A1<B1 ->= (Greater than or equal to) +>= (Greater than or equal to) -Greater than or equal to +Greater than or equal to -A1>=B1 +A1>=B1 -<= (Less than or equal to) +<= (Less than or equal to) -Less than or equal to +Less than or equal to -A1<=B1 +A1<=B1 -<> (Inequality) +<> (Inequality) -Inequality +Inequality -A1<>B1 +A1<>B1

Text operators

-The operator combines separate texts into one text. +The operator combines separate texts into one text. -Operator +Operator -Name +Name Example @@ -228,29 +228,29 @@ -& (And) +& (And) -text concatenation AND +text concatenation AND -text concatenation AND +text concatenation AND -"Sun" & "day" is "Sunday" +"Sun" & "day" is "Sunday"

Reference operators

-These operators return a cell range of zero, one or more cells. -Range has the highest precedence, then intersection, and then finally union. +These operators return a cell range of zero, one or more cells. +Range has the highest precedence, then intersection, and then finally union. -Operator +Operator -Name +Name Example @@ -258,38 +258,38 @@ -: (Colon) +: (Colon) -Range +Range -A1:C108, A:D or 3:13 +A1:C108, A:D or 3:13 -! (Exclamation point) +! (Exclamation point) -intersection operator +intersection operator -Intersection +Intersection -SUM(A1:B6!B5:C12) -Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6. +SUM(A1:B6!B5:C12) +Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6. -~ (Tilde) +~ (Tilde) -Concatenation or union +Concatenation or union -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. +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. =COUNT(A1:B2~B2:C3) counts values of A1:B2 and B2:C3. Note that the cell B2 is counted twice. =INDEX(A1:B2~C1:D2;2;1;2) selects cell C2, that is, the first cell of the second row, first column, of the second range (C1:D2) of the range list. -- cgit