<< 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):

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.