Sheetsdrill

Level 1: Basics Exercise 15 of 92

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.

Functions used: ROUNDUP

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 exercise

More exercises in Basics