How to Use Excel s MROUND Function
How to Use Excel's MROUND Function GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
Number (required) is the value you want to round up or down to the nearest multiple. This argument can contain the actual data for rounding, or it can be a cell reference to the location of the data in the worksheet. Multiple (required) is the multiple to which you want to round the number. Some things to note about the MROUND function's arguments: The number and multiple arguments must have the same sign. That is, if the number is positive, then the multiple must be positive. If the number is negative, the multiple must also be negative. If not, the function returns a #NUM! error in the cell.If the number and multiple arguments are both negative, the function returns a negative number.If the multiple argument is zero (0), the function returns a value of zero.
How to Use Excel's MROUND Function
How to round up or down to the nearest 5 cents in Excel
By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on June 21, 2022 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint OutlookWhat to Know
Select cell > Formulas tab > Math & Trig icon > MROUND > select Number line > select reference cell.Next, select Multiple line > enter value to round to > Done. This article explains how to use the MROUND function to automatically round numbers up or down in Microsoft Excel 2010, 2013, 2016, 2019, and in Excel for Microsoft 365.Using Excel' s MROUND Function
Options for entering the function and its arguments include: Typing the complete function into a worksheet cellSelecting the function and its arguments using the Function Dialog Box Many people find it easier to use the dialog box to enter a function's arguments as it takes care of the function's syntax. =MROUND(A2,0.05) Take the following steps to enter the function in the image above into cell C2 using the Function Dialog Box: Select cell C2 to make it the active cell. Select the Formulas tab of the ribbon. Select on the Math & Trig icon to open the function drop-down. Select MROUND in the list to open the Function Dialog Box. Select the Number line. Select cell A2 in the worksheet to enter this cell reference as the number argument. Select the Multiple line. Type in 0.05 so that the number in cell A2 will be rounded up or down to the nearest multiple of 5 cents. Select Done to return to the worksheet. The value 4.55 should appear in cell C2 since it is the nearest multiple of 0.05 larger than 4.54. When you select cell C2, the complete function will appear in the formula bar above the worksheet.MROUND Function Syntax and Arguments
The layout of a function is called its syntax which includes the function's name, brackets, and arguments. The syntax for the MROUND function is: =MROUND(Number,Multiple)Number (required) is the value you want to round up or down to the nearest multiple. This argument can contain the actual data for rounding, or it can be a cell reference to the location of the data in the worksheet. Multiple (required) is the multiple to which you want to round the number. Some things to note about the MROUND function's arguments: The number and multiple arguments must have the same sign. That is, if the number is positive, then the multiple must be positive. If the number is negative, the multiple must also be negative. If not, the function returns a #NUM! error in the cell.If the number and multiple arguments are both negative, the function returns a negative number.If the multiple argument is zero (0), the function returns a value of zero.