Excel Study · Module 1: First steps
Class 5Maths order: why brackets matter
Basics1:41 videoFree
Excel does maths in a fixed order: brackets first, then powers, then multiply and divide, then add and subtract. So =B2+C2*1.05 taxes only the delivery charge, while =(B2+C2)*1.05 adds 5% to price AND delivery.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2 has a price and C2 has a delivery charge. Write a formula that adds them together and then adds 5% tax to the total.
The answer that works
✓ checked in Excel=(B2+C2)*1.05
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.