Description
The Excel MROUND function rounds any referred number to a multiple of the given number ( in the example of the above image it is 5)
This function like the ROUND and INT function follows the general rule of rounding numbers.
The Excel MROUND Function is different from the other rounding functions as this function rounds to the multiple of a given number.
Whereas in the functions like ROUND, ROUNDUP and ROUNDDOWN a fraction is rounded to a given number of digits.
=MROUND(number,multiple)
The MROUND function’s syntax has the following arguments:
- number Required.
This argument shall be the number (even stored as text) or reference to the number you want to round. In the example given in the image above the number “32” and the cell B3 (i.e. reference to the number) is our required argument.
- multiple Required.
The number of which the multiple is required.
