# MROUND function in Excel

> MROUND rounds a number to the nearest multiple of another number.

Source: https://spreadsheetpractice.com/functions/mround · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** MROUND rounds a number to the nearest multiple of another number.
- **Syntax:** `=MROUND(number, multiple)`
- **Most common use:** `=MROUND(B2,15)` returns 30 (Nearest quarter hour: 37 minutes becomes 30)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The multiple of multiple that is closest to number.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

MROUND rounds a number to the nearest multiple of another number. It's the quickest way to round to the nearest 5, the nearest quarter hour or the nearest nickel. It goes up or down, whichever is closer, and exact halves round up.

## Syntax

`=MROUND(number, multiple)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The value to round. |
| `multiple` | Required | The multiple to round to, such as 5, 15 or 0.05. It must have the same sign as number. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=MROUND(B2,15)` | 30 | Nearest quarter hour: 37 minutes becomes 30 |
| D3 | `=MROUND(C3,0.05)` | $4.40 | Nearest nickel: $4.42 becomes $4.40 |
| D4 | `=MROUND(B4,15)` | 30 | Exactly halfway (22.5) rounds up to 30 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Task | Minutes | Cost |  |
| 2 | Design review | 37 | $19.97 | 30 |
| 3 | Client call | 52 | $4.42 | $4.40 |
| 4 | Setup | 22.5 | $12.50 | 30 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #NUM! | number and multiple have different signs, such as =MROUND(-10,3). Make them match: =MROUND(-10,-3) returns -9. |
| It rounded down when you needed up | MROUND picks the nearest multiple. To always round up use CEILING, and to always round down use FLOOR. |
| Odd results with times | Times are fractions of a day. Round them with a time multiple, such as =MROUND(A2,"0:15"), not 15. |

## Tips

- Billing in tenths of an hour? Round minutes with =MROUND(B2,6).

## Related functions

- [ROUND](https://spreadsheetpractice.com/functions/round): ROUND rounds a number to the number of digits you choose.
- [CEILING](https://spreadsheetpractice.com/functions/ceiling): CEILING rounds a number up to the next multiple you choose: the next 5, the next dozen, the next quarter hour.
- [FLOOR](https://spreadsheetpractice.com/functions/floor): FLOOR rounds a number down to the previous multiple you choose: down to the nearest 10, the nearest quarter, or the start of a price band.

## Questions

### How do I round to the nearest 5 in Excel?

Use =MROUND(A2,5). For the nearest 0.5, use =MROUND(A2,0.5).

### How do I round a time to the nearest 15 minutes?

Use =MROUND(A2,"0:15") and format the result as a time.

### Why does MROUND return #NUM!?

The number and the multiple have opposite signs. Use a negative multiple for negative numbers.

## Practice

A graded MROUND exercise ("Bill in six-minute blocks") is on [the MROUND page](https://spreadsheetpractice.com/functions/mround). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
