Excel practice · Basics

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

  1. Round up to a whole number of boxes
  2. Round down to a safe whole number
  3. Round up a price to the next cent
  4. Round a measurement down to the nearest bucket size
  5. Round a duration up to the next time slot

The exercises

1. Round up to a whole number of boxes Easy

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."

AB
1Items134
2Per box12
3Boxes 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.

2. Round down to a safe whole number Easy

A caterer has a $500 budget and each meal costs $37.50. ROUNDDOWN tells you how many full meals that budget can actually cover.

AB
1Budget500
2Cost per meal37.5
3Meals 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.

3. Round up a price to the next cent Easy

A product costs $4.372 to make. Round that up to the nearest cent so you're never pricing it below cost.

AB
1Raw cost4.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.

4. Round a measurement down to the nearest bucket size Medium

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.

AB
1Weight (kg)138
2Bucket size25
3Nearest 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.

5. Round a duration up to the next time slot Medium

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.

AB
1Estimated minutes38
2Slot size15
3Minutes 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 →

More basics practice

All Excel practice exercises · Excel test prep