MROUND Excel Formula

Author Zaheer    Category Formulas     Tags ,

Excel offers an array of functions which you can choose from and use for specific computations. But before doing so you must first enable the Analysis ToolPak of Excel. You can do this by clicking on the Tools and hit the Add-Ins button. A drop down list will then appear and from the list select the Add-Ins Available list and on it click the Analysis ToolPak and hit OK.

Now you have enabled the Analysis ToolPak you can now use the Math Function of Excel and to more specific the MROUND function.

The MROUND function allows you to round up or down a given number to its closest compound of a certain number. The MROUND function syntax is MROUND (number, multiple). The number argument in the syntax is the number to round up or down. Likewise, the multiple argument in the syntax is the multiple of which the number will be rounded to. Both the number and the multiple arguments must have same sign which is positive or negative.

For example, on your blank Excel spreadsheet label column A with Number and label column b with MROUND. On cell A2 input the value 333.7 and on cell B2 input the formula = MROUND (A2, 0.5) and the result will be 333.5. Another example, in cell A3 input the value 555 and on the opposite cell, B3 input the formula =MROUND (A6, 1000) and the result will be 1000.

As what we have stated above, positive must be paired with positive and negative must be paired with negative. An example is on cell A4 input the numerical value -555.7 and on the opposite cell input the formula =MROUND (A7,-1) and the result will be 556.

To view the results and switch it in viewing the formulas you can do that by pressing Ctrl+` (grave accent). You can also switch views to values from formula on the Formulas tab right click on the Formula Auditing and hit the Show Formula selection.

The error that you might encounter while using this function is the #NUM! error. This error happens when the number argument in the syntax has a different sign with the multiple values in the syntax.

Post comment