Parentheses in Formulas
Parentheses in Formulas
Taking Control of the Order of Calculations
By default, Excel follows standard mathematical rules to decide which part of a formula to calculate first. Parentheses ( ) are your way of "interrupting" those rules to tell Excel exactly what matters most.
The Power of Brackets: A Comparison
=2 + 3 * 4
Excel follows Operator Priority. It multiplies 3 by 4 first, then adds 2.
Result: 14
=(2 + 3) * 4
The brackets Force Excel to add 2 and 3 first, then multiply by 4.
Result: 20
🧠 How Excel "Thinks" (BODMAS / PEMDAS)
Excel processes math in this specific order:
- Brackets
( )(Highest Priority) - Orders
^(Exponents/Powers) - Division & Multiplication
/and* - Addition & Subtraction
+and-
💡 Skill Eco Pro-Tip: "When in Doubt, Bracket it Out"
Even if you don't need them, adding parentheses can make your formulas much easier to read for other people. It clearly shows which parts of the calculation belong together.
Example: =(A1*B1) + (C1*D1) is much easier to understand than =A1*B1+C1*D1.
🏋️ Test Yourself With Exercises
Take our quiz on Parentheses in Formulas to test your knowledge.
Exercise »