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 |