The MROUND function rounds a number up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

MROUND takes 2 required arguments and no optional arguments:

Syntax: MROUND(number, multiple)

#1)
Using the MROUND function:
#2)
The arguments for the MROUND function are:
Argument Required? Description
number Required The value to round.
multiple Required The multiple to which you want to round number.

Summary

The MROUND function rounds a number up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.
comments powered by Disqus