<< Click to Display Table of Contents >> Operators in formulas |
Formulas can contain any of the operators listed below.
Please note that operators follow a strict order of precedence, which defines the evaluation order of expressions containing operators: Operators with higher precedence are evaluated before operators with lower precedence.
Parentheses can be used to override the order of precedence and force parts of a formula to be evaluated before other parts.
For example, 1+2*2 returns 5, since multiplication has precedence over addition. If the formula (1+2)*2 is used instead, the result will be 6, since the parentheses override the order of precedence.
Operators available, listed in order of precedence (top = highest):
1st |
Space |
Intersection (see also INTERSECTION function) |
2nd |
% |
Percentage |
3rd |
+ |
Positive sign (not addition!) |
|
– |
Negative sign (negation)* (not subtraction!) |
4th |
^ |
Exponentiation* |
5th |
x |
Multiplication |
|
/ |
Division |
6th |
+ |
Addition |
|
– |
Subtraction |
7th |
& |
Concatenation (For example, "Plan" & "Maker" returns "PlanMaker") |
8th |
= |
Is equal |
|
<> |
Is not equal |
|
< |
Is less |
|
> |
Is greater |
|
<= |
Is less or equal |
|
>= |
Is greater or equal |
* | Note: To ensure compatibility with Microsoft Excel, the order of precedence for the exponentiation operator (^) and the negation operator (-) is changed, but mathematically incorrect. For example, the correct mathematical order (first exponentiation, then sign) for the formula -2^2 would lead to the mathematically correct result -4. However, the actual result in PlanMaker (and in Excel) is 4. |