Kornilios Ampatzis/ April 19, 2019/ Functions

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:

Practice

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

Share this Post