Always round up with ROUNDUP
PremiumIn C2, work out how many boxes are needed for the items in A2 when each box holds B2. A part-full box is still a box, so use ROUNDUP with 0 decimals.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Items | Per box | Boxes needed | |||
| 2 | 130 | 24 | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock ROUND, ROUNDUP and ROUNDDOWN and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:Relative and absolute referencesPercentages
It comes up in this mock test: Excel test for job interviews
Need help?
Why this works
130 / 24 is 5.42. ROUND would give 5, which leaves 10 items without a box. ROUNDUP(number, 0) always goes to the next whole number away from zero, so you get 6.
Common mistake: Using ROUND for a number of boxes. 5.42 rounds down to 5, which leaves items without a box.
The answer
- C2
=ROUNDUP(1A2/B2,20)
In plain words: Round 1the items in A2 divided by the number per box in B2 up to 2a whole number.