Thread: rounding a number created by a formula to a retail price
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jack jack is offline
external usenet poster
  
Posts: 186
Default rounding a number created by a formula to a retail price
I want to round a price that i have created by using a formula to .09, .19,
..29, ......99. Example - the price I created by using a formula is $5.64 and
I would like to round it to $5.59 or $5.69.
Reply With QuoteReply With Quote