In this Excel tutorial you will teach yourself how to round to nearest 5.

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) **