Formula to round retails to specific ending numbers

Hi all,
I'm working with retail price points and I'd like to round them to certain numbers. The hundreths digit of my retails have to round up and end in either a 3,5,7, or 9. Some examples would be $1.51 rounds to $1.53, $1.28 rounds to $1.29, etc. This would be easier if I could include my prices ending in a 1 but I am only allowed to round to 3,5,7, or 9. Thank you so much for taking the time to help.

Hi

This does assume that you will always have 2 dec places.

=LEFT(A1,3)+VLOOKUP(RIGHT(A1,1),{"0",0.03;"4",0.05;"6",0.07;"8",0.09},2)

HTH

rylo

Thank you for the fast replies!

Rylo your formula works great from .00 to .09 but anything ending with .10 and greater causes the formula to create a vaule of .03,.05,.07,.09. Ex: $1.11 is creating a value of $1.03.

shg your formula is almost there. =FLOOR(A1, 0.1) + LOOKUP(MOD(100*A1, 10), {0,4,6,8}, {3,5,7,9}%)
I changed your formula to match what I wanted to do by making it into
=FLOOR(A1, 0.1) + LOOKUP(MOD(100*A1, 10), {3,5,7,9}, {3,5,7,9}%), however for some reason numbers like .10, .20, .30, etc are displaying an error.

Thank you both for your help so far.

Thanks shg! That fixed it!