Article updated on April 19, 2018

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

Formula in cell D3:

=MROUND(B3,C3)

Excel Function Syntax

MROUND(number, multiple)

Arguments

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

Comments

Warning, the rounding direction is undefined for midpoint numbers.