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:
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.
- 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.
- Number – The input number that you need to round.
- Significance – The “multiple” by which you want to round the number.
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.
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.
The following video will show you how to use the Excel MROUND function in the spreadsheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?