This **Excel** tutorial shows how to **round a number to nearest multiple** using different functions. Once provided with a specific number, the nearest multiple of the number will be returned.

Rounding a number to nearest multiple in Excel can be done using the MROUND, CEILING or FLOOR function. These functions round different values ranging from times, measurements, and other numeric values.

**Formula or Syntax**

**=MROUND(number, multiple)**

**How to round a number to the nearest multiple?**

The MROUND function is used to round numbers to the closest multiple. The CEILING function rounds up numbers while the FLOOR function rounds down the number to its nearest multiple. Let’s consider the illustration below.

- Let’s say we are to round a specified number to its nearest multiple using the three functions. Enter the MROUND function into the cell.

* Figure 1. The MROUND function round a number to its nearest multiple.*

- Using the same multiple of 5 for the CEILING function, the becomes ‘50’.

*Figure 2. The CEILING function is used to round up numbers to the nearest multiple of 5.*

- Let’s consider rounding down the number to the nearest multiple of 10. The FLOOR function is used for this purpose.

*Figure 3. The FLOOR function is used to round down the number to the multiple of 10.*

- Let’s round the number to the nearest multiple of 10 by using the MROUND function.

*Figure 4. The MROUND function rounds numbers to the closest multiple specified.*

**Notes**

- The MROUND function rounds numbers up or down based on how close the number is to the multiple.
- The CEILING function rounds up while the FLOOR function rounds down the number.

## Leave a Comment