Before posting a question, consider searching Google Groups for your
answer. I remember seeing posts for this same question. I searched
for your title "Rounding to nearest 5 cents in excel" in the Excel
Functions group and received two pages of hits.

http://groups.google.com/group/micro...rch+this+group



- John