I forgot something...

Next five cents:
=ROUNDUP(A1/0.05,0)*0.05
=CEILING(A1,0.05)

Nearest five cents:
=ROUND(A1/0.05,0)*0.05

"Jeff Jensen" wrote:

Next five cents:
=ROUNDUP(A1/0.05,0)*0.05

Nearest five cents:
=ROUND(A1/0.05,0)*0.05

"sruarg" wrote:

i would like to round a currency amount to the next $ 0.05 (five cents)

eg 30.63 to be 30.65 or 40.48 to be 40.50