|
|
The following table lists the operators to be performed in cell formula data.
|
Operator Type
|
Operator
|
Description
|
|
Arithmetic
|
+
|
Addition
|
|
|
-
|
Subtraction
|
|
|
/
|
Division
|
|
|
*
|
Multiplication
|
|
|
%
|
Percentage
|
|
|
^
|
Exponentiation
|
|
Text
|
&
|
Concatenation
|
|
Comparison
|
=
|
Equal to
|
|
|
>
|
Greater than
|
|
|
<
|
Less than
|
|
|
>=
|
Greater than or equal to
|
|
|
<=
|
Less than or equal to
|
|
|
<>
|
Not equal to
|
|
Reference
|
:, .., .
|
Range - produces a reference that includes all the cells between the two references (e.g., A1:A3 includes cells A1 and A3 and all cells in between).
|
|
|
,
|
Union - produces one reference that includes the two references (e.g., A1:A8,B1:B7).
|
|
|