# How to Use Excel MROUND Function?

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 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 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.