Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
MROUND
MROUND rounds a number to the nearest specified multiple. If the remainder when dividing by the multiple is at least half the multiple, it rounds up; otherwise it rounds down. Use it to snap prices, durations, or measurements to a grid.
Excel
=MROUND(A2,0.25)Google Sheets
=MROUND(A2,0.25)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Price | Rounded |
| 1.37 | |
| 2.63 | |
| 4.11 | |
| 0.88 |
=MROUND(A2,0.25)→1.25
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the number you want to round (e.g. 1.37).
- 20.25 is the multiple to round to — the result will be a multiple of 0.25.
- 3MROUND returns the nearest multiple, so 1.37 rounds to 1.25 and 1.38 rounds to 1.50.