| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to round currency?
Is there a way to round currency with cents=.50 to .99 and cents <=.49 to .49?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to round currency?
Try this:
For a value in A1 B1: =FLOOR(A1,0.5)+0.49 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "jpowers" wrote: Is there a way to round currency with cents=.50 to .99 and cents <=.49 to .49? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorrect Currency Displayed | Excel Discussion (Misc queries) | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| Can you format a whole column of numbers to round? | Excel Worksheet Functions | |||
| Currency Style button | Excel Discussion (Misc queries) | |||
| I am trying to round currency to the closest .50, can anyone tell. | Excel Discussion (Misc queries) | |||
Linear Mode
