Google Sheets
MROUND function in Google Sheets
Rounds one number to the nearest integer multiple of another.
=MROUND(value, factor)MROUND syntax and parameters
Two arguments, two required.
- valuenumberRequired
The number to round to the nearest integer multiple of another.
- factornumberRequired
The number to whose multiples value will be rounded.
MROUND examples
Formulas you'll actually reuse.
To the nearest 5 cents — cash rounding:
=MROUND(B2, 0.05)Result
23.8Minutes rounded to the nearest quarter hour:
=MROUND(B2, 15)Result
45
MROUND in Excel
Same name — your formula ports as-is.
Try MROUND in the playground
Edit the example — nothing to install.
Preloaded with the MROUND formula from Example 1 — change anything and watch it respond.
Loading the editor…
MROUND errors
What they mean — and the fixes.
#NUM!The number and the multiple have different signs — both must be positive or both negative.
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel