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
|