View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
usnst
 
Posts: n/a
Default Rounding to nearest 5 cents in excel

Can anyone provide me with a formula that can round a price to the nearest 5
cents? for example 11.33 would be 11.35 11.36 would be 11.35 11.38 would be
11.40. So the price would always end in a '5' or a '0'.