MROUND function
MROUND rounds a number to the closest multiple of another number and returns the result. Typical uses are the nearest 5 minutes or the nearest 0.05 in pricing.
Example
Read it as a sentence: round 10 to the nearest multiple of 3, which gives 9.
A
B
C
D
1
9
2
3
Syntax
MROUND(number, multiple)
-
number(required) - The value to round.
-
multiple(required) - The multiple to round to.
Returns: The number rounded to the nearest multiple.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=MROUND(10,3) | 9 | 10,3 |
=MROUND(-10,-3) | -9 | -10,-3 |
=MROUND(10,0) | 0 | Multiple 0 |
=MROUND(7.5,5) | 10 | Midpoint 7.5,5 |
=MROUND(1.3,0.2) | 1.4 | 1.3,0.2 |
=MROUND("10","3") | 9 | Text number |
=MROUND(-10,3) | #NUM! | -10,3 signs differ |
=MROUND(10,-3) | #NUM! | 10,-3 |
Watch out for
- Number and multiple must have the same sign or you get #NUM!.
- Exact halves round away from zero.
Where it works
- Excel
- MROUND is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .