Rounding currency
I want to round a long price list which currently has dollars and
cents into whole dollars such that the end result cell is whole dollars without cents. Rick |
Rounding currency
Hi Rick
Price list. Assuming you want to round UP then. =ROUNDUP(A1,0) ....or the more common =ROUNDUP(A1,0)-0.01 which generates great bargains like 22.99 . Try even =CEILING(A1,5)-0.01 to get 24.99 instead. HTH. Best wishes Harald skrev i melding oups.com... I want to round a long price list which currently has dollars and cents into whole dollars such that the end result cell is whole dollars without cents. Rick |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com