Quick Navigation

MROUND Function

Excel 2007+

Summary

The Excel MROUND function rounds a number to the nearest specified multiple. Unlike standard ROUND which rounds to decimal places, MROUND rounds to any multiple you specify - perfect for currency, inventory, scheduling, and measurement applications.

Syntax

MROUND(number, multiple)

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	The numeric value you want to round
multiple	`Number`	Yes	The increment to round to (must have same sign as number)

Using the MROUND Function

MROUND excels in scenarios requiring rounding to specific increments like tax calculations, package sizes, or production batches. It provides precise control over rounding behavior by specifying the exact multiple rather than decimal places.

Common MROUND Examples

Basic Rounding to Multiple

=MROUND(10, 3)

Rounds 10 to nearest multiple of 3 (result: 9)

Negative Number Rounding

=MROUND(-10, -3)

Rounds -10 to nearest multiple of -3 (result: -9)

Decimal Multiple Rounding

=MROUND(1.3, 0.2)

Rounds 1.3 to nearest multiple of 0.2 (result: 1.4)

Sign Mismatch Error

=MROUND(5, -2)

Returns #NUM! error due to different signs between number and multiple

Frequently Asked Questions

#NUM! error is returned. Both must be positive or both negative.

Rounds away from zero when remainder >= half the multiple value.

ROUND rounds to decimal places; MROUND rounds to specified multiples.

Common Errors and Solutions

#NUM!

Cause: Number and multiple have different signs

Solution: Ensure both arguments have the same sign (both positive or both negative)

#VALUE!

Cause: Non-numeric arguments provided

Solution: Verify both inputs contain valid numbers

Inconsistent decimal rounding

Cause: Midpoint decimal values with decimal multiples

Solution: Test specific values or use alternative rounding functions

Notes

Rounds up (away from zero) if remainder >= half the multiple
Available in Excel 2007 and later versions
Decimal multiple midpoint behavior may vary slightly
Consider CEILING/FLOOR for directional rounding control

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+