View Single Post
  #3   Report Post  
Old August 17th 09, 09:30 PM posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 921
Default Round price to end in .99

How about =round(price,0)-.01

"Chip" wrote:

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?