Rounding to 5 cents

Is there a formula to round to the nearest five cents?

By Neale Blackwood, 22 Jun 09

You can use the ROUND function to do it. If the number is in cell A1, this formula will work:

=0.05 * ROUND(A1/0.05,0)



This formula rounds 2.5 cents and 7.5 cents up to the nearest 5 cents.

This formula will work to round to any number. Just replace both 0.05’s in the formula with the number you want to round to.

First published: CPA Australian Magazine February 2003 – Page 55 Excel Yourself