Round to Nearest 5 Cents
To round a result to the nearest 5 cents, use the Excel function MROUND:
=MROUND(your_number_here,0.05)
For example, if the number to be rounded is in cell A1, it would be:
=MROUND(A1,0.05)
Round to Nearest 5 Cents with the ROUND function
The MROUND function is not available in older versions of Excel (before 2007). Fortunately, it is still possible to round a result to the nearest 5 cents using only the ROUND function.
Here is the formula to use:
=ROUND((your_number_here)/0.05,0)*0.05
or
=ROUND((your_number_here)*20,0)/20
For example, if the number to be rounded is the result of the division of A2 by B2, it would be:
=ROUND((A2/B2)/0.05,0)*0.05
or
=ROUND((A2/B2)*20,0)/20