The function MROUND rounds a number to a given multiple.
This function takes a two Numbers as input: a base number to round, and another number describing which place to round the base number to. It returns another Number: the given number, rounded to the specified place.
Declaration
MROUND(base_number, base) -> rounded_number
Parameters
base_number (required, type: Number)
The number to round.
base (required, type: Number)
The multiple to round to.
This specifies which multiple to round to. For instance, a base of 10 will round the given number to the nearest ten, while a base of 0.01 will round the given number to the nearest hundredth.
Return Values
rounded_number (type: Number)
The base number rounded to the given multiple.
Examples
The following example takes the the number 1.5 and rounds it to the nearest integer:
MROUND(1.5, 1) -> 2
The following example takes the number 5.8899 and rounds it to the nearest hundredth:
MROUND(5.8899, 0.01) -> 5.89
The following example takes the number 32 and rounds it to the nearest ten:
MROUND(32, 10) -> 30
Discussion
In terms of rounding functionality, the MROUND function behaves identically to the ROUND function; the only difference between the two is that MROUND uses a multiple to describe which place to round to, whereas ROUND uses the number of digits.