Assuming your price is in A1

=IF(INT(A1*10)INT((A1-0.06)*10),(INT(A1*10)+0.5)/10,(INT(A1*10)+0.9)/10)

--
Ian
--
"bound4LIFER" wrote in message
...
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