Round To Nearest 5 Excel Formula

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.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.