BODMAS Rule in Excel – Quick and Easy Guide 2026
Watch the tutorial
Introduction – We’ve all used formulas in Excel and sometimes wondered why the result wasn’t what we expected. That’s where the BODMAS rule in Excel comes in. BODMAS stands for Brackets, Orders, Division/Multiplication, Addition, and Subtraction. It’s the sequence Excel follows to calculate formulas.
For example, if you type 10 + 5 * 2, you might expect 30, but Excel gives you 20. Why? Because it first does multiplication (5 × 2 = 10) and then adds 10, giving you 20. That’s BODMAS in action!
Why is the BODMAS Rule in Excel Important?
The BODMAS rule matters because:
It prevents wrong results caused by incorrect order of operations.
Ensures consistency across all formulas.
Helps you write accurate formulas without confusion.
Saves time by reducing errors and rework.
Makes formulas easier to understand and debug.
You’ll find it extremely useful in calculations like discounts, taxes, percentages, and other complex Excel formulas.
Real-Life Example of BODMAS Rule in Excel: Discount Calculation
Let’s say you have sales data with quantity, price, and discount.
You want to calculate the final price with this formula:
=Quantity * Price – Discount
Suppose Quantity = 2, Price = 5,000, and Discount = 10%.
You expect 9,000 (because 10,000 – 10% = 9,000).
But Excel gives a different result. Why?
Because it’s applying BODMAS like this:
First, it multiplies 2 × 5000 = 10,000
Then it applies subtraction incorrectly with the percentage
You end up with the wrong number
How to Fix It with Brackets
To make Excel calculate the way you want, use brackets to control the order.
Instead of writing:
=B2 * C2 – 10%
Write:
=B2 * C2 * (1 – 10%)
Here’s what happens step by step:
1 – 10% = 90%
Excel multiplies 10,000 × 90%
Final result = 9,000 (correct!)
By adding brackets, you guide Excel to evaluate the formula in the order you intend.
How to use Evaluate Formula (see BODMAS Rule in Excel in action)
Select the cell with the formula.
Go to Formulas → Evaluate Formula.
Click Evaluate repeatedly — Excel will show each intermediate step so you can follow the BODMAS order.
