|
|
The following table lists the order of precedence for formula operators.
|
Operator
|
Description
|
|
( )
|
Parentheses
|
|
:, .., .
|
Range
|
|
,
|
Union
|
|
-
|
Negation (single operand)
|
|
%
|
Percentage
|
|
^
|
Exponentiation
|
|
* and /
|
Multiplication and Division
|
|
+ and -
|
Addition and Subtraction
|
|
&
|
Text concatenation
|
|
= < > <= >= <>
|
Comparison
|
Operators of like precedence are evaluated left to right. Parentheses should be used when it is necessary to change the order of evaluation.
For example, 3 + 4*2 evaluates to 11, and (3 + 4)*2 evaluates to 14.
|
|