View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bound4LIFER bound4LIFER is offline
external usenet poster
 
Posts: 2
Default Rounding Up For Retail Pricing

Could someone please help me with the formula to always round up To 5's and
9's in the hundredths digit. For example if the amount is $3.20- $3.25 it
would round to $3.25. If the the number is $3.26 - $3.29, it would round up
to $3.29. I am using the following formula already to calculate pricing from
cost in Excel 2003 and currency formulations. =(I3/9)/.54+1.12