How to Use Excel MROUND Function?

Ads

Listen to this article.

The MROUND function is categorized under Excel Math and Trigonometry functions. This function will return a number rounded to the multiple given by the user. MROUND will always round up away from zero. If you want to round up a dozen values in your spreadsheet, you can use this built-in function.

This article will understand the Excel MROUND Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Description of MROUND Function

It is one of the built-in functions in Microsoft Excel.
This function returns a number rounded to the given multiple.
It will round the number to the nearest multiple (“±” to the multiple values) of the given input value.

Syntax

Here, you will see the syntax of the MROUND function.
To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
Once you enter the formula, just click on the Enter button to get the result.

=MROUND(number, significance)

Argument Description:

Number – The input number that you need to round.
Significance – The “multiple” by which you want to round the number.

Note:
1) The number and significance must have the same sign, or else it returns #NUM! Error value.
2) If you use any non-numeric values such as letters or special characters, it returns #VALUE! Error.

Use Excel MROUND Function

Here is an example of the MROUND function. It is similar to the ROUND function.

The input numbers and their multiples are given in Columns B and C.

Apply the above-mentioned formula. And the rounded output values are listed in Column E.

Finally, we need to click on the Enter button to get the result. Drag-down the first cell to fill the remaining cells.

Input that causes Error

By seeing the below-given example, you will understand the input that causes errors in the spreadsheet.

The number and significance must have the same sign, or else it returns #NUM! Error value.

Verdict

In this article, you can understand the usage of the Excel MROUND Function with its syntax, description, and examples. Give your suggestions in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.