View Single Post
  #5   Report Post  
Old August 17th 09, 09:49 PM posted to microsoft.public.excel.misc
Chip Chip is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 40
Default Round price to end in .99

Thanks.....it worked just as requested. I appreciate your help.

"Lars-Åke Aspelin" wrote:

On Mon, 17 Aug 2009 13:18:01 -0700, 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?



Try this formula:

=ROUNDUP(A1,0)-0.01

Hope this helps / Lars-Åke