How to Use MROUND Function

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.

Download: MROUND Function

Leave a Reply