Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i would like to round a currency amount to the next $ 0.05 (five cents)
eg 30.63 to be 30.65 or 40.48 to be 40.50 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting monetary amounts with currency indicator on extreme left and amount right ? | Excel Discussion (Misc queries) | |||
Rounding dollar amounts up/down when cents aren't part of the fact | Excel Worksheet Functions | |||
Currency Rounding to nearest 5 cents | Excel Discussion (Misc queries) | |||
Formula for rounding a column of currency to a multiple | Excel Worksheet Functions | |||
Rounding currency. | Excel Worksheet Functions |