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'.
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'.
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
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'.
"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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks