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.
MROUND(base_number, base) -> rounded_number
- 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.
- rounded_number (type: Number)
- The base number rounded to the given multiple.
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
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.