ROUNDUP, ROUNDDOWN, FLOOR & CEILING practice exercises
5 graded problems with realistic data, from easy to medium.
Four ways to round in a chosen direction, instead of to the nearest value the way plain ROUND does. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the ROUNDUP, ROUNDDOWN, FLOOR & CEILING guide first: syntax, a worked example and the mistakes people make.
In this set
- Round up to a whole number of boxes
- Round down to a safe whole number
- Round up a price to the next cent
- Round a measurement down to the nearest bucket size
- Round a duration up to the next time slot
The exercises
You're packing 134 items into boxes of 12. ROUNDUP tells you how many whole boxes you actually need: no box can be "0.67 full."
| A | B | |
|---|---|---|
| 1 | Items | 134 |
| 2 | Per box | 12 |
| 3 | Boxes needed | ? |
Enter a formula in B3.
Show a hint
ROUNDUP(number, digits) always rounds away from zero. With digits as 0: =ROUNDUP(B1/B2,0).
ROUND would round 11.17 down to 11 boxes and leave items with nowhere to go; ROUNDUP is the right tool whenever a fraction of the unit isn't usable.
A caterer has a $500 budget and each meal costs $37.50. ROUNDDOWN tells you how many full meals that budget can actually cover.
| A | B | |
|---|---|---|
| 1 | Budget | 500 |
| 2 | Cost per meal | 37.5 |
| 3 | Meals affordable | ? |
Enter a formula in B3.
Show a hint
ROUNDDOWN(number, digits) always rounds toward zero: =ROUNDDOWN(B1/B2,0).
Rounding 13.3 meals up to 14 would overspend the budget; ROUNDDOWN is the safe direction whenever going over the real number isn't an option.
A product costs $4.372 to make. Round that up to the nearest cent so you're never pricing it below cost.
| A | B | |
|---|---|---|
| 1 | Raw cost | 4.372 |
| 2 | ? |
Enter a formula in A2.
Show a hint
A positive digits argument rounds to that many decimal places: =ROUNDUP(B1,2).
ROUNDUP with decimals is how prices get rounded in the seller's favor: the same idea as rounding up units, just at the level of cents instead of whole items.
A warehouse only ships in multiples of 25 kg. A shipment weighs 138 kg. FLOOR tells you the largest multiple of 25 that still fits.
| A | B | |
|---|---|---|
| 1 | Weight (kg) | 138 |
| 2 | Bucket size | 25 |
| 3 | Nearest multiple at or below | ? |
Enter a formula in B3.
Show a hint
FLOOR(number, significance) rounds down to the nearest multiple of significance: =FLOOR(B1,B2).
FLOOR and CEILING round to a multiple of any number you choose, not just powers of ten: nickels, pallets, time slots, anything that only comes in fixed-size units.
Appointments are booked in 15-minute slots. A task is estimated to take 38 minutes. CEILING tells you how many minutes to actually block off.
| A | B | |
|---|---|---|
| 1 | Estimated minutes | 38 |
| 2 | Slot size | 15 |
| 3 | Minutes to block | ? |
Enter a formula in B3.
Show a hint
CEILING(number, significance) rounds up to the nearest multiple of significance: =CEILING(B1,B2).
Booking systems, billing increments, and shipping tiers all round up to the next allowed unit; CEILING is that rule as a formula instead of a mental calculation.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the ROUNDUP, ROUNDDOWN, FLOOR & CEILING exercises →