What are Excel operators? Definition, types, and order of precedence

Microsoft states the rule in one sentence: "Excel calculates the formula from left to right, according to a specific order for each operator in the formula." Left to right is the tie-breaker, not the rule; the specific order comes first.

The four families of operator

Microsoft groups them by what they do: arithmetic for "basic mathematical operations such as addition, subtraction, or multiplication", comparison to "compare two values", text concatenation to "join, or concatenate, one or more text strings", and reference operators that "combine ranges of cells for calculations".

Two repay a second look. Comparison operators return TRUE or FALSE rather than a number, which makes them the raw material of every logical test — the subject of Boolean logic. And the space is a genuine operator, not whitespace: =SUM(B7:D7 C6:C8) returns the value of C7, the one cell the two ranges share. Type a space where a comma belonged and Excel obediently intersects two ranges that do not overlap, which is where the #NULL! value described under Formula errors comes from.

The order of precedence

When a formula mixes operators, Microsoft applies them in this order:

Ties are broken by position: "if a formula contains operators with the same precedence … Excel evaluates the operators from left to right."

Exceljet's summary is a mnemonic with a warning attached: "In general, Excel's order of operation follows the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) but with some customization to handle the formula syntax in a spreadsheet." The customisation is where the surprises live.

Negation outranks exponentiation

This is the best-known departure from school arithmetic. In Microsoft's table negation sits at rank 2 and exponentiation at rank 4, so the minus sign is applied before the power is. =-2^2 therefore squares negative two and returns 4, where the mathematical convention reads it as the negative of two squared and gives -4. Write =-(2^2) if you mean the latter and =(-2)^2 if you mean the former. The difference only shows up when the exponent is even, which is why it survives review.

Percent is an operator, not a proportion

Microsoft's example for % is =20%, and that is all the operator does: it converts the number in front of it into its hundredth part. It takes no percentage of anything. So =100+10% is not 110 — it is 100 plus 0.1. A percentage of a value needs a multiplication: =100*(1+10%), or a reference to the cell holding the rate.

Comparison happens last

Comparison sits at the bottom of the table, below concatenation and all the arithmetic, so both sides finish calculating before the comparison runs. =1+1=2 returns TRUE because the addition resolves first, and ="a"&"b"="ab" returns TRUE for the same reason — which is what lets you write a condition without bracketing either side.

Parentheses beat everything

The escape hatch is the one every spreadsheet user already knows. Microsoft: "To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first." Their example is the whole idea in two formulas — =5+2*3 returns 11 because the multiplication runs first, =(5+2)*3 returns 21 because the brackets promote the addition. Exceljet frames it as an override: "Parentheses essentially override the normal order of operations to ensure certain operations are performed first."

What follows is a habit rather than a rule: a formula whose meaning depends on remembering that % outranks ^ will be misread. Brackets you did not strictly need cost nothing and remove the question.

Google Sheets

The operators carry over. Ablebits' guide to Sheets formulas describes the same four groups: arithmetic operators "used to perform math calculations such as adding, subtracting, multiplication, and division", comparison operators "used to compare two values and return a logical expression: TRUE or FALSE", the ampersand, which "is used to connect (concatenate) multiple text strings into one", and reference operators that "indicate data ranges".

The evaluation rule is stated the same way: "Each formula in Google Sheets handles its values in some particular order: from left to right based on operator precedence." So an arithmetic or comparison expression written for one application behaves the same in the other. What does not travel reliably is everything around the operators — function names, argument separators, array behaviour.

How Formula Foundry handles this

Precedence bugs are silent. A formula with the brackets in the wrong place returns a plausible number rather than an error value, and no tool — in Excel, in Sheets, or in Formula Foundry — can tell you a correct-looking result is wrong, because only you know what the formula was meant to say.

What Formula Foundry attacks is the reason those bugs survive: you cannot see the structure. In the formula bar a nested expression is one long line where every bracket looks like every other bracket. In the add-on's editor the same formula opens across multiple lines with indentation that follows the nesting, matching parentheses highlighted, and colour by token type — functions, ranges, constants and named references each get their own. A term that drifted outside the brackets it belonged in becomes a shape you notice rather than a character you have to count to. The visual builder makes the grouping explicit differently, rendering the formula as a form with each argument named and nested groups shown as groups.

The parser catches the mechanical half before the formula reaches the cell: unbalanced brackets, a missing operator between two pieces of a concatenation, and other syntax faults, collected in one pass rather than one at a time. What it cannot do is arithmetic — it never evaluates the workbook, so it cannot tell you that =100+10% is 100.1. The free playground runs the editor in the browser with nothing to install; the spreadsheet still computes the answer.

FAQ