Operators

Operators are the basic building blocks used in formulas to combine values, compare results, and create conditions. They are used directly in formulas, and often inside functions such as IF.

Use this section to understand operator behavior and navigate to the relevant reference page.

Start here if…

Quick rules

• Use parentheses to make intent explicit
• Without parentheses, * and / are evaluated before + and -
• Functions evaluate inside out
• + and - aggregate both inputs to their common dimensions (the intersection of the shared dimensions)
• * and / calculate across the combined dimension set (the union of both inputs’ dimensions)

Related sections

• Formula basics: parentheses, evaluation order, notation
• Function catalog: functions used together with operators
• Troubleshooting guide: common pitfalls with comparisons and missing values