Operators in $[officename] Calc
/text/scalc/01/04060199.xhp
formulas; operators
operators; formula functions
division sign, see also operators
multiplication sign, see also operators
minus sign, see also operators
plus sign, see also operators
text operators
comparisons;operators in Calc
arithmetical operators
reference operators
mw added 7 new index entriesOperators in $[officename] Calc
You can use the following operators in $[officename] Calc:
Arithmetical Operators
These operators return numerical results.
Operator
Name
Example
+ (Plus)
Addition
1+1
- (Minus)
Subtraction
2-1
- (Minus)
Negation
-5
* (asterisk)
Multiplication
2*2
/ (Slash)
Division
9/3
% (Percent)
Percent
15%
^ (Caret)
Exponentiation
3^2
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.
Operator
Name
Example
= (equal sign)
Equal
A1=B1
> (Greater than)
Greater than
A1>B1
< (Less than)
Less than
A1<B1
>= (Greater than or equal to)
Greater than or equal to
A1>=B1
<= (Less than or equal to)
Less than or equal to
A1<=B1
<> (Inequality)
Inequality
A1<>B1
Text operators
The operator combines separate texts into one text.
Operator
Name
Example
& (And)
text concatenation AND
text concatenation AND
"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.
Operator
Name
Example
: (Colon)
Range
A1:C108
! (Exclamation point)
intersection operator
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.
~ (Tilde)
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. See note below this table.
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.