The MROUND function is one of the math and trigonometry functions in Microsoft Excel. It can be used as a standalone function and in collaboration with the other functions. This article will give you an overview of the MROUND function in Excel.
The MROUND function rounds off a numerical value to the nearest multiple of a given number. It rounds up or down depending on the distance of the nearest multiple.
- number: It refers to the number to round off.
- multiple: The number to whose multiple you want to round off your number.
A rounded-off version of the input number.
Examples of MROUND Function
Suppose, you have the number 3.4 in cell A2. Using the MROUND function, you can round off the number to the nearest multiple of any desired number. Suppose, you want to round off 3.4 to the nearest multiple of 3. For that, use the formula:
The output will be 3.
Here are some examples of the usage of the MROUND function.
Usage Guide of MROUND Function
Step_1: Start with inserting an equal sign (=) in a blank cell.
Step_2: Then type MROUND.
Step_3: Type open parenthesis “(“.
As you type the open parenthesis, Excel shows the syntax of the MROUND function.
Step_4: Insert a number to round off.
You can directly insert a number or a cell address that contains a number.
Step_5: Then insert a comma (,).
After inserting the comma, Excel will ask you for the second argument: the multiple.
Step_6: Now specify the number to whose multiple you want to round off your number.
I want to round off the number to the nearest multiple of 2. So, I have inserted 2 inside the function.
The MROUND function converts 3.4 into 4. Because here, the multiple is 2. The multiples of 2 are 0,2,4,6, etc. The nearest multiple of 2 to 3.4 is 4. So the formula returns 4.
- The MROUND function shows #VALUE! error in the case of the non-numeric values.
- When the sign of the number and multiple are opposite, the MROUND function returns a #NUM! error.
- If the number is an exact multiple of the desired multiple, the MROUND function doesn’t make any change.
Related Rounding Functions
- ROUND Function ⋙ rounds to the given number of decimal places.
- ROUNDUP Function ⋙ rounds up a numerical value to a specific decimal place.
- ROUNDDOWN Function ⋙ rounds down a numerical value to a specific decimal place.
- CEILING Function ⋙ rounds up a numerical value to the nearest integer or the nearest multiple of significance.
- FLOOR Function ⋙ rounds down a numerical value to the nearest multiple of significance.
- INT Function ⋙ rounds down a numerical value to the nearest integer number.
- TRUNC Function ⋙ removes specific digits from the fraction part of a number.
The MROUND function is one of the math and trigonometry functions in Excel. If you have any questions regarding the MROUND function, please comment below. Thanks!