Level 1Formulas & ReferencesPractice, 3 min
Order of operations
The task
A coffee costs $1.75 to make and sells for $5.50. In D2, find total profit on the units sold: (price minus cost) times units.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Price | Cost | Units | Profit |
| 2 | 5.5 | 1.75 | 40 |