MROUND Function
Rounds a number to the nearest multiple of a given value.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| number | The value to round. | Required |
| multiple | The multiple to which you want to round. Must share the sign of number. | Required |
Basic Example
Round 10 to the nearest multiple of 3
=MROUND(10, 3)The multiples of 3 nearest to 10 are 9 (distance 1) and 12 (distance 2), so 9 is returned.
Advanced Examples
Example 1: Tie-breaking rounds away from zero
When exactly halfway between two multiples.MROUND rounds a half-multiple away from zero.
=MROUND(7.5, 2)Example 2: Round to a decimal multiple
Snap a value to the nearest 0.05.Pass multiple 0.05.
=MROUND(0.87, 0.05)How MROUND Works
MROUND divides number by multiple, rounds that quotient to the nearest integer (rounding half away from zero), then multiplies back. number and multiple must have the same sign, or the function returns #NUM!.
Important Notes & Limitations
number and multiple must share the same sign; opposite signs return #NUM!.
When the value is exactly halfway between two multiples, MROUND rounds away from zero.
Results are floating-point and may show tiny rounding artifacts.
Common Errors & Fixes
#NUM!number and multiple have opposite signs.Fix: Use the same sign for both arguments.
#VALUE!Non-numeric argument.Fix: Supply numeric values.
Download Practice File
MROUND
mroundPractice MROUND with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the MROUND function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps