BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points
Calculate line totals with multiplication
The situation
A customer has queried their invoice. You need to rebuild the line totals for Harbor Supply's order ORD-1046 so you can check the figures against what was billed.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Quantity | Unit price | Line total | |
| 2 | Galvanized bracket | 120 | $18 | ||
| 3 | Roofing nail box | 45 | $32 | ||
| 4 | Sealant tube | 200 | $9 | ||
| 5 | |||||
| 6 |