Rounding to nearest 5 cents in excel
 

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'.

Rounding to nearest 5 cents in excel
 

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

Rounding to nearest 5 cents in excel
 

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

"usnst" wrote:

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'.

Rounding to nearest 5 cents in excel
 

"usnst" wrote:
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.