# Excel MROUND Function

HomeExcel FunctionsExcel 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: 