Thread: Rounding Up
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
farid2001 farid2001 is offline
external usenet poster
  
Posts: 56
Default Rounding Up
Hello

Try =ROUNDUP(A1,-1)-0.01

Regards
farid2001

"EFF" wrote:

Need help with formula to round (always round up) pricing to the next $9.99.
Reply With QuoteReply With Quote