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.