Operators in formulas

<< 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 and is thus calculated first. If the formula (1+2)*2 is used instead, the result will be 6, since the parentheses override the order of precedence.

Operators listed in order of precedence (highest first):

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 to

 

<>

Is not equal to

 

<

Is less than

 

>

Is greater than

 

<=

Is less than or equal to

 

>=

Is greater than or equal to

Note: To ensure compatibility with Microsoft Excel, the order of precedence for the exponentiation operator (^) and the negation operator (-) is reversed 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.