It rounds a number to a specific multiple.
The syntax of the function is the following:
MROUND(number, multiple)
number: The number you want to round.
multiple: The multiple to which you want to round the number.
The number and multiple arguments must have the same sign. If not, a #NUM error is returned
To always round up, use the ROUNDUP function.
To always round down, use the ROUNDDOWN function.
To round a number to a specified number of digits, use the ROUND function.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the MROUND function:
In the cell Α1 insert the number π using the proper function. Then, in the cell B1, round the value of the cell A1 to the nearest multiple of 0.2