View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default Round price to end in .99

try =roundup(a1,0)-.01
assuming data to round is in cell a1


"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?