Boxes to ship
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
The units in B1 are packed into boxes that hold the number in B2. A partly filled box still has to ship. Put the number of boxes in B3.
What this exercise teaches
ROUND would give 10 boxes for 250 units and leave 10 units behind. ROUNDUP always goes up, and an exact multiple such as 240 stays at 10.
A hint if you get stuck
ROUNDUP(value, 0) rounds up to the next whole number. Put the division inside it.
Try it now, free, no account needed
Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exerciseMore exercises in Basics
- Total ad spend
- Average order value
- Round the unit price
- One rate for every row
- Over budget?
- Share of total sales
- Month-over-month growth
- Price after discount
- Commission over a threshold
- Count the survey responses
- Running balance
- Cheapest and most expensive plan
- A rate that cannot divide by zero
- Count the ticked checkboxes