Related Functions:

The MROUND function rounds a supplied number up or down to the nearest multiple of a given number.

Syntax

=MROUND(number,multiple)

Arguments

Argument Description
number The value to round
multiple The multiple that the supplied number should be rounded to

Note: The multiple argument should have the same sign, positive or negative, as the number argument.

Examples

  A B C
1 Formula Result Notes
2 =MROUND(10,3 9 Rounds 10 to the nearest multiple of 3
3 =MROUND(-10,-3) -9 Rounds -10 to the nearest multiple of -3
4 =MROUND(10.5,2) 10 Rounds 10.5 to the nearest multiple of 2
5 =MROUND(33.4,2) 34 Rounds 33.4 to the nearest multiple of 2
6 =MROUND(1.3,0.2) 1.4 Rounds 1.3 to the nearest multiple of 0.2

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the multiple argument has a different arithmetic sign, positive or negative, than the number argument