Rounding To Nearest 5 In Excel
Your task is to round a number in A1 cell to nearest 5. Excel can do that! The main function which does that is MROUND. You can use that formula:
=MROUND(A1,5)
The same does ROUND function with this formula:
=ROUND(A1/5,0)*5
The disadvantage of MROUND is that it doesn’t work when you round a negative number.
If you prefer other function there are two more: CEILING and FLOOR. They work the same such as MROUND but CEILING round up and FLOOR round down.
=CEILING(A1,5)
=FLOOR(A1,5)
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
