View Single Post
  #4   Report Post  
Old August 17th 09, 09:31 PM posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 913
Default Round price to end in .99

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