| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding to the nearest 50 cents
Excel 2003 running on Win XP... all SP
We usually round to the nearest dollar mark, but now they want to get more exact. So now our Customer Service wants rounding to the nearest 50 cents. Example: $15.64 would equal $15.50 $15.88 would equal $16.00 I've looked in roundup functions and can't find a way to do this. Any help would be greatly appreciated. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the nearest 50 cents
One way:
=ROUND(A1*2,0)/2 In article , Jerid B wrote: Excel 2003 running on Win XP... all SP We usually round to the nearest dollar mark, but now they want to get more exact. So now our Customer Service wants rounding to the nearest 50 cents. Example: $15.64 would equal $15.50 $15.88 would equal $16.00 I've looked in roundup functions and can't find a way to do this. Any help would be greatly appreciated. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the nearest 50 cents
=MROUND(A1,0.5)
tyr this "Jerid B" wrote: Excel 2003 running on Win XP... all SP We usually round to the nearest dollar mark, but now they want to get more exact. So now our Customer Service wants rounding to the nearest 50 cents. Example: $15.64 would equal $15.50 $15.88 would equal $16.00 I've looked in roundup functions and can't find a way to do this. Any help would be greatly appreciated. Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the nearest 50 cents
Hi,
Try: =MROUND(A1,0.5) HTH Jean-Guy "Jerid B" wrote: Excel 2003 running on Win XP... all SP We usually round to the nearest dollar mark, but now they want to get more exact. So now our Customer Service wants rounding to the nearest 50 cents. Example: $15.64 would equal $15.50 $15.88 would equal $16.00 I've looked in roundup functions and can't find a way to do this. Any help would be greatly appreciated. Thank you! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding to the nearest 50 cents
=MROUND(A1,0.5) needs Analysis ToolPak
otherwise =ROUND(A1*2,0)/2 -- David Biddulph "Jerid B" wrote in message ... Excel 2003 running on Win XP... all SP We usually round to the nearest dollar mark, but now they want to get more exact. So now our Customer Service wants rounding to the nearest 50 cents. Example: $15.64 would equal $15.50 $15.88 would equal $16.00 I've looked in roundup functions and can't find a way to do this. Any help would be greatly appreciated. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding figures to nearest thousand | Excel Worksheet Functions | |||
| Currency Rounding to nearest 5 cents | Excel Discussion (Misc queries) | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Rounding to nearest 5 cents in excel | Excel Worksheet Functions | |||
| Rounding to nearest integer | Excel Worksheet Functions | |||
Linear Mode
