How to Round to the Nearest 5 in Google Sheets
Use =MROUND(A2,5) to round a number to the nearest multiple of 5. Change 5 to 10, 0.5 or any step you need.
=MROUND(A2,5)
MROUND rounds to the nearest multiple of the second argument. Use 10 for nearest ten, 0.5 for nearest half.
How it works
MROUND rounds a value to the nearest multiple of a step you choose, rounding up or down to whichever multiple is closer. When you always want to go up to the next multiple use CEILING; to always go down use FLOOR. These are better than plain ROUND whenever your target is a step like 5, 25 or 0.05 rather than a number of decimal places.
Variations
Always round up to the next 5
=CEILING(A2,5)
CEILING pushes up to the next multiple, e.g. 11 becomes 15.
Always round down to the previous 5
=FLOOR(A2,5)
FLOOR drops to the lower multiple, e.g. 14 becomes 10.
Round price to the nearest 0.05
=MROUND(A2,0.05)
Handy for pricing to the nearest five cents.
Examples
| Scenario | Formula |
|---|---|
| Round minutes to the nearest 5 | =MROUND(A2,5) |
| Round a price up to the next 10 | =CEILING(A2,10) |
FAQ
What is the difference between MROUND and ROUND?
ROUND rounds to decimal places; MROUND rounds to the nearest multiple of a step like 5 or 25.
How do I always round up?
Use CEILING: =CEILING(A2,5) never goes below the original value.
Can I round to the nearest quarter?
Yes — =MROUND(A2,0.25) rounds to the nearest 0.25.
Related formulas
- How to Generate a Random Number in Google Sheets
- How to Get the Day of the Week from a Date in Google Sheets
- How to Sum Across Multiple Sheets in Google Sheets
- "Array Result Was Not Expanded" in Google Sheets — How to Fix It
- "Did Not Find Value in VLOOKUP Evaluation" — How to Fix It
- Google Sheets Formula Not Calculating (Showing as Text) — Fix It
- "Wrong Number of Arguments" in Google Sheets — How to Fix It
- How to Calculate a Running Total in Google Sheets