BeginnerExcel Basics
Convert loose units into full cases
Divide a unit count by the case size to see how many cases were ordered.
3 min10 points
Work out gross margin per order
The situation
Harbor Supply's sales report shows revenue by order but not what any of it cost. Finance is trying to work out which customers are genuinely profitable, and the cost of goods sits in the column beside it.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Revenue | Cost | Margin | |
| 2 | SO-6301 | $4,820 | $3,155 | ||
| 3 | SO-6302 | $2,140 | $1,690 | ||
| 4 | SO-6303 | $7,350 | $4,980 | ||
| 5 | SO-6304 | $1,180 | $1,240 | ||
| 6 | SO-6305 | $5,600 | $3,420 | ||
| 7 |
Who this is for
Recommended next
Related exercises
- BeginnerFormulas
Calculate line totals with multiplication
Multiply quantity by unit price to get a line total.
3 min10 points - BeginnerFormulas
Calculate achievement against target
Divide actual sales by target to get an achievement percentage.
3 min10 points - BeginnerExcel Basics
Convert loose units into full cases
Divide a unit count by the case size to see how many cases were ordered.
3 min10 points