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)

**Large Number Rounding**

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

**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.