Using the Excel MROUND Function
SummaryThe MROUND function returns a number rounded to a desired multiple. The MROUND function will always round up (away from zero).
Syntax=MROUND (number, multiple)
Required. The number that you wish to round.
Required. The multiple to which you wish to round the number.
Usage NotesThe MROUND function will round a number up to a desired multiple.
Number and Multiple Signs
Both number and multiple must have the same signs. If they do not, the function returns the #NUM! error.
Other Rounding Functions
Excel has various rounding functions that can be used in different situations.