# How does the MROUND function work?

• 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

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.

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

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

Back to Software Bytes – Official Website

Back to Excel Tutorial