Author: Oscar Cronquist Article last updated on April 19, 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.