Rounding Up For Retail Pricing
One way:
=CEILING(I3/4.86+1.12,0.05)-(MOD(I3/4.86+1.12,0.1)0.05)/100
In article ,
"bound4LIFER" wrote:
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
|