- Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.
This post will cover how the MROUND function works in Microsoft Excel. It features a description of it, its formula syntax, essential conditions to remember with its use, and also an example for you to play around with.
The MROUND function simply yields a number rounded to the target multiple.
Formula Syntax of MROUND Function
The MROUND function syntax contains these particular arguments:
- Number – Required. The value in question to round.
- Multiple – Required. The multiple that you are seeking to round number.
Conditions of MROUND Function
- MROUND rounds up, thus the opposite direction from zero, if the remainder of dividing number by multiple is higher than or equal to half the value of multiple.
- The Number and Multiple arguments are required to include the same sign. If not, a #NUM error is returned.
Copy the sample data in the below table, and paste it into cell A1 of a new Excel worksheet. For formulas to display results, pick them, press F2, and then press Enter. If you have to at any point, you can modify the column widths to view the entire dataset in all its magnificence.
|=MROUND(10, 3)||Rounds 10 to the nearest multiple of 3.||9|
|=MROUND(-10, -3)||Rounds -10 to the nearest multiple of -3.||-9|
|=MROUND(1.3, 0.2)||Rounds 1.3 to the nearest multiple of 0.2.||1.4|
|=MROUND(5, -2)||Returns the #NUM! error message because -2 and 5 have different signs.||#NUM!|
Once a decimal value is supplied to the Multiple argument, the rounding direction is unclassified for midpoint numbers. For instance, MROUND(6.05,0.1) returns 6.0 while MROUND(7.05,0.1) brings back 7.1.#
Expand your Office skills
Get instant Excel help.
Subject to Got It terms and conditions.