Thread: Rounding Up
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Rounding Up
EFF wrote:
Need help with formula to round (always round up) pricing to the next $9.99.


=ROUNDUP(A1+0.01,-1)-0.01

This assumes you want $100.00 to round up to $109.99 and not down to $99.99. If
that's wrong, drop the first "0.01".
Reply With QuoteReply With Quote