Excel MROUND Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel MROUND Function (Example + Sample File)

What is EXCEL MROUND FUNCTION

The Excel MROUND Function is listed under Microsoft Excel's Maths Functions category. It returns a number after rounding it to a given multiple. In simple words, the MROUND rounds a number to the nearest multiple of a number and while rounding, it doesn’t consider that number is greater or lower than the original number.

How to use it

To learn how to use the MROUND function in Excel, you need to understand its syntax and arguments:

Syntax

MROUND(number, multiple)

Arguments

  • number: A number to round.
  • multiple: A number for which you want to find the nearest multiple.

Notes

  • If you put zero in multiple it will return zero in the result.
  • If you skip specifying multiple it will return with an error.
  • It rounds away from zero.
  • If you have two multiples on the same distance it will return the multiple which is higher than the number you are rounding.

Example

To master the MROUND function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used different arguments:

  1. 12.5 rounded to 12 to the nearest multiple of 3 is 12.
  2. 19 is rounded to 20 to the nearest multiple of 5
  3. 13 is rounded to 12 to the nearest multiple of 6.
  4. 3.6 is rounded to 2 to the nearest multiple of 4.
  5. The result is 0 as I have skipped specifying multiple.
  6. The result is 0 as I have specified 0 as the multiple.
  7. The result is an error as I have specified -2 as multiple.
  8. Here we have a tie between 20 and 18, but we get 20 as it always rounds away from zero.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.