MROUND function

The MROUND function in Excel is used to round a number to the nearest multiple of a specified value. It can be useful for tasks like rounding prices to the nearest nickel or rounding quantities to match a specific unit.

Syntax

MROUND(number, multiple)

Arguments

numberThe number you want to round to the nearest multiple.
multipleThe multiple to which you want to round the number.

How to use

The MROUND function is quite straightforward. You provide it with a number you want to round (the ‘number’ argument) and the value to which you want to round it (the ‘multiple’ argument). The function will then round the ‘number’ to the nearest multiple of the ‘multiple’ value.

Here’s an example:

In this case, Excel will round 17 to the nearest multiple of 5, which is 15.

You can also use negative numbers with the MROUND function. For instance:

Excel will round -9 to the nearest multiple of 3, which is -9 itself.

If the ‘multiple’ value is a decimal, it will still work. For example:

Excel will round 8.75 to the nearest multiple of 0.25, which is 8.75 as well.

Remember that if the ‘number’ is equidistant between two multiples, the MROUND function will round to the nearest even multiple. For example:

Excel will round 5 to the nearest multiple of 2, which is 6.

[Optional] You can use the MROUND function in various scenarios, such as financial calculations, unit conversions, and data formatting, where rounding to specific multiples is required. This function can help you ensure that numbers align with your desired precision or format.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.