About this lesson
Operators and order of operations
Excel's operators are + - * / and ^ (to the power of), and it works them out in BODMAS order: brackets, then ^, then * and /, then + and -. So =(E2+E3)/1000 adds before dividing, while =E2+E3/1000 divides E3 alone.
=B2*C2What you'll practise
Recalculate a client's sales schedule on an audit team: multiply, subtract inside brackets, fix a BODMAS mistake and compound with ^.
4 steps · 40 points · the cells outlined in gold below
- operators
- order of operations
- brackets
- exponents
- editing formulas
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product line | Units (k) | Price | Unit cost | Revenue ($k) | Gross profit ($k) |
| 2 | Timber framing | 64 | $38.50 | $29.20 | ||
| 3 | Plasterboard | 41 | $24.90 | $17.40 | ||
| 4 | Fixings | 128 | $12.40 | $7.10 | ||
| 5 | Paint | 23 | $68.00 | $44.50 | ||
| 6 | ||||||
| 7 | Revenue ($m) | 0.0 | ||||
| 8 | Price growth a year | 4% | ||||
| 9 | FY29 revenue ($m) |