IntermediateLogical Functions
Work out fill rate without a divide error
Guard a division so cancelled lines do not fill the report with errors.
IF
8 min25 points
Convert loose units into full cases
The situation
Harbor Supply's warehouse picks by the case, but the online store sends orders through in individual units. The pick list needs the case count, and each product line packs a different number to a case.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Product | Units | Case size | Cases | |
| 2 | Work gloves | 288.00 | 12.00 | ||
| 3 | Shop towels | 480.00 | 24.00 | ||
| 4 | Cable ties | 1000.00 | 100.00 | ||
| 5 | Safety goggles | 144.00 | 6.00 | ||
| 6 | Utility knives | 250.00 | 25.00 | ||
| 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 - BeginnerExcel Basics
Work out gross margin per order
Subtract cost from revenue to find what each order actually earned.
3 min10 points - BeginnerExcel Basics
Work out remaining leave days
Subtract leave taken from entitlement to see what each person has left.
3 min10 points