Operators in OpenOffice.org Calc
You can use the following operators in OpenOffice.org 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 |
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 |
"Sun" & "day" is "Sunday" |
Reference operators
These operators merge cell ranges.
Index
formulas, operators
operators, formula functions
text concatenation AND
intersection operator
This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.
