How to Use CEILING, FLOOR, and MROUND in Excel
Introduction
Your timesheet shows 3.3 hours, but the client agreement bills in quarter-hour increments. That's not a decimal-places problem, so ROUND doesn't apply. CEILING, FLOOR, and MROUND round to any multiple you choose.
The Dataset
Here's a timesheet for a freelance design studio:
| A | B | C | |
|---|---|---|---|
| 3 | Project | Hours | Rate |
| 4 | Logo Design | 3.3 | 160 |
| 5 | Website Copy | 1.7 | 120 |
| 6 | Social Pack | 4.6 | 100 |
| 7 | Email Template | 0.8 | 140 |
| 8 | Brand Guide | 6.4 | 200 |
The studio bills in quarter-hour increments (0.25 hours). Every project needs its hours rounded before the invoice goes out.
CEILING
CEILING rounds up to the next multiple. The syntax is:
=CEILING(number, significance)
- number: The value to round.
- significance: The multiple to round up to.
To round the Logo Design hours up to the nearest quarter hour:
=CEILING(B4, 0.25)
The result is 3.5. The raw 3.3 sits between 3.25 and 3.5 on the quarter-hour scale, so CEILING pushes it up to 3.5.
| Project | Hours | Billable |
|---|---|---|
| Logo Design | 3.3 | 3.5 |
| Website Copy | 1.7 | 1.75 |
| Social Pack | 4.6 | 4.75 |
| Email Template | 0.8 | 1.0 |
| Brand Guide | 6.4 | 6.5 |
The Email Template jumps from 0.8 to 1.0. A few minutes into a new quarter still bills for the full increment, which is standard for hourly billing but adds up fast on small tasks.
Key takeaway: CEILING rounds up to the next multiple of whatever significance you specify. Use it when the rounding should always favor the higher number: billing increments, minimum order quantities, or shipping container sizes.
FLOOR
FLOOR goes the other direction. It rounds down to the previous multiple:
=FLOOR(number, significance)
- number: The value to round.
- significance: The multiple to round down to.
=FLOOR(B4, 0.25)
This returns 3.25. Where CEILING pushed 3.3 up to 3.5, FLOOR pulls it back to 3.25.
| Project | Hours | CEILING | FLOOR |
|---|---|---|---|
| Logo Design | 3.3 | 3.5 | 3.25 |
| Website Copy | 1.7 | 1.75 | 1.5 |
| Social Pack | 4.6 | 4.75 | 4.5 |
| Email Template | 0.8 | 1.0 | 0.75 |
| Brand Guide | 6.4 | 6.5 | 6.25 |
FLOOR works for conservative estimates. If you're quoting a project and want to keep the number tight, rounding hours down gives you a buffer without changing the rate.
MROUND
MROUND rounds to the nearest multiple, whichever direction is closer:
=MROUND(number, multiple)
- number: The value to round.
- multiple: The multiple to round to.
=MROUND(B4, 0.25)
This returns 3.25. Since 3.3 is closer to 3.25 than to 3.5, it rounds down. But for Website Copy, MROUND(1.7, 0.25) returns 1.75, because 1.7 is closer to 1.75 than to 1.5.
| Project | Hours | CEILING | FLOOR | MROUND |
|---|---|---|---|---|
| Logo Design | 3.3 | 3.5 | 3.25 | 3.25 |
| Website Copy | 1.7 | 1.75 | 1.5 | 1.75 |
| Social Pack | 4.6 | 4.75 | 4.5 | 4.5 |
| Email Template | 0.8 | 1.0 | 0.75 | 0.75 |
| Brand Guide | 6.4 | 6.5 | 6.25 | 6.5 |
Across all five projects, CEILING bills 17.5 hours, FLOOR bills 16.25, and MROUND bills 16.75. The raw total is 16.8. Over enough line items, MROUND lands closest to the actual time because the ups and downs tend to cancel out.
Other Multiples
The quarter-hour example uses 0.25, but these functions take any positive number as the multiple:
| Goal | Formula | Result |
|---|---|---|
| Round a price to the nearest $5 | =MROUND(47, 5) | 45 |
| Round a budget up to the next $100 | =CEILING(2340, 100) | 2400 |
| Round an estimate down to the nearest $1,000 | =FLOOR(8700, 1000) | 8000 |
The multiple controls the grid. CEILING, FLOOR, and MROUND just decide which grid line the value snaps to.
Conclusion
ROUND handles decimal places. CEILING, FLOOR, and MROUND handle multiples. Pick CEILING when you always round up, FLOOR when you always round down, and MROUND when you want the nearest value.
For rounding to a specific number of decimal places, see our guide on ROUND, ROUNDUP, and ROUNDDOWN.
Level up your Excel skills
Bite-sized lessons, drills, and daily challenges to build real spreadsheet skills.