The MROUND function returns a rounded number.
Formula:
=MROUND(number, multiple)
Explanations:
– The number is required, the number to round.
– Multiple is required, the multiple you need to round a number.
Cautions:
– When the reminder is greater than or equals to a half of the multiple, the MROUND function rounds up away from zero.
– When reminder and number have different signs, the MROUND function returns #NUM! error.