# Round to nearest 5

=MROUND(number,5)

If you need to round a number to the nearest multiple of 5, you can use the MROUND function and supply 5 for number of digits.

In the example, cell C6 contains this formula:

=MROUND(B6,5)

The value in B6 is 17 and the result is 15 since 15 is the nearest multiple of 5 to 17.

### Other multiples

As you'd expect, you can use MROUND to round to other multiples as well:

And so on.

### Force up or down

You can use the CEILING function to force rounding up to the nearest multiple and the FLOOR function to force rounding down to the nearest multiple.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

## Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.