How to use the Excel MROUND function

MROUND is the MATH & TRIGNOMETRY function in excel and is used to convert the number to the nearest multiple numbers of the given number. For example, =MROUND(50,7) will convert the number 50 to 49 because number 7 nearest multiple 49, in this case, it has rounded down to the nearest value. Similarly, if the formula is =MROUND(53,7) then this will convert the number 53 to 56 because multiple number 7 nearest number for number 53 is 56, in this, it has rounded up to nearest multiple values odd number 7.

As a financial analyst, the MROUND function helps round a number and eliminate the least significant digits, making it simpler but keeping close to the original value.

Syntax: =MROUND (number, multiple)

The MROUND function syntax has the following arguments:

  • Number    Required. The value to round.
  • Multiple    Required. The multiple to which you want to round number.

Example: Let’s look at some Excel MROUND function examples and explore how to use the MROUND function as a worksheet function in Microsoft Excel:

Example 1:

Excel MROUND function - How to use the Excel MROUND function

Syntax:  =MROUND(A2,B2)

Result:

MROUND function - How to use the Excel MROUND function

Based on the Excel spreadsheet above, the following MROUND examples would return:

Syntax: =MROUND(A3,B3)
Result: 8

Syntax: =MROUND(A4,B4)
Result: 8

Syntax: =MROUND(A5,B5)
Result: 3855

Syntax: =MROUND(A6,B6)
Result: 4000

Syntax: =MROUND(A7,B7)
Result: 3900

Syntax: =MROUND(A8,B8)
Result: 6

Syntax: =MROUND(A9,B9)
Result: 270

Note:

  • If a number is already an exact multiple, no rounding occurs.
  • Rounding occurs when the remainder from dividing number by multiple is greater than or equal to half the value of multiple
  • Number and multiple must have the same sign.
  • Common Errors
    #NUM! – Occurs if the multiple argument has a different arithmetic sign (positive or negative) to the number argument.
    #VALUE! – Occurs if any of the supplied arguments are non-numeric.

Example 2: 

Let’s see how the MROUND function can be used to get a time rounded up to the nearest 45-minute interval. Suppose we are given the data below:

Excel MROUND - How to use the Excel MROUND function

Syntax: =MROUND(A2,”0:45″)

Result:

MROUND function in excel - How to use the Excel MROUND function

Add a Comment

Your email address will not be published. Required fields are marked *