Thread: Round to .05 or .09
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruce Bruce is offline
external usenet poster
  
Posts: 138
Default Round to .05 or .09
How can I round prices to the nearest 0.05 or 0.09?

Eg 1
5.01 to 4.99
Eg 2
4.44 to 4.45

Regards,

Bruce
Reply With QuoteReply With Quote