Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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'. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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'. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Rounding to the nearest 9th | Excel Discussion (Misc queries) | |||
why is excel rounding my totals down | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Rounding time in excel (2003) | Excel Discussion (Misc queries) |