How does the MROUND function work?

A merry-go-round - represents the MROUND function. Image by Narelle Steckyj from Pixabay
  • 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.

A merry-go-round - represents the MROUND function.
Image by Narelle Steckyj from Pixabay.

Formula Syntax of MROUND Function

MROUND(number, multiple)

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.
A round piece of railing from a building - represents the MROUND function.
Image by analogicus from Pixabay.

Example

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.

FormulaDescriptionResult
=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!

Known Restrictions

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

Other Links

Back to Software Bytes – Official Website

Back to Excel Tutorial

Expand your Office skills

EXPLORE TRAINING

Got It

Get instant Excel help.

CONNECT TO AN EXPERT NOW 

Subject to Got It terms and conditions.

Leave a Reply

%d bloggers like this: