MROUND Function

The MROUND function in Excel will round a number up or down to a given multiple. The multiple is defined in the formula.

Syntax:

=MROUND (number, multiple)

Arguments:

  • number – The number that should be rounded.
  • multiple – Specified multiple to use when rounding.

MROUND Function Example

Let’s review the following example in cell A6.

Our defined multiple is 2. What this means is Excel will use this multiple and round to the nearest multiple of 2 getting as close to possible to our number, 16.

2*2*2*2=16

=MROUND(A6,B6) 
MROUND DEMO

Large Number Rounding

In this example, we demonstrate how to use large number rounding. Excel rounds to the given multiple.

MROUND2

Round Pricing to nearest .99

Here we use the following formula to round pricing to the nearest $0.99.

=MROUND(A15,B15)-0.01

Rounding Functions in Excel

ROUND Function – Rounds to a specified number of digits.

ROUNDUP Function – Rounds numbers up a specified decimal place.

ROUNDDOWN Function – Returns a number rounded down to a specified number of places.

FLOOR Function – Rounds a given number down to the nearest specified multiple

MROUND Function – Round a number up or down to a given multiple.

CEILING Function – Rounds a given number up to the nearest specified multiple.

INT Function – Rounds a number down to the nearest integer.

TRUNC Function – Returns a truncated number based on a specified number of digits.