Thread: rounding a number created by a formula to a retail price
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default rounding a number created by a formula to a retail price
=ROUNDDOWN(A1,1)+0.09


"Jack" wrote:

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