Article updated on February 16, 2018

The MROUND function calculates a number rounded to a given multiple.

Formula in cell D3:


Excel Function Syntax

MROUND(number, multiple)


number Required. The value to round.
multiple Required. The multiple you want to use.


Warning, the rounding direction is undefined for midpoint numbers.