Rounding to nearest 5 cents in excel

[usnst]

Can anyone provide me with a formula that can round a price to the nearest 5
cents? for example 11.33 would be 11.35 11.36 would be 11.35 11.38 would be
11.40. So the price would always end in a '5' or a '0'.

 

[John Michl]

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/micr...s+in+excel&qt_g=1&searchnow=Search+this+group



- John

 

[bj]

try = round(A1*20,0)/20

 

[joeu2004]

Can anyone provide me with a formula that can round
a price to the nearest 5 cents? for example 11.33 would
be 11.35 11.36 would be 11.35 11.38 would be
11.40. So the price would always end in a '5' or a '0'.

.... and 11.32 would be 11.30? Or do you really want to
always round up?

For rounding (not round up):

=MROUND(A1, 0.05)

where A1 is the price. If that results in a #NAME? error,
look at the MROUND Help text to see how to "install" the
Analysis ToolPak.