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