Returns a number rounded to the desired multiple.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
Number is the value to round.
Multiple is the multiple to which you want to round number.
MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.
MROUND(10, 3) equals 9
MROUND(-10, -3) equals -9
MROUND(1.3, 0.2) equals 1.4
MROUND(5, -2) equals #NUM!