< Go Back

Round a number to nearest multiple

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.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar