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.
It comes up in this mock test: Excel test for job interviews
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
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.