Retail Pricing Rounded to nearest 9

[steve22727]

I am trying to find a formula on how to round retail prices so that the
will end with the nearest nine, i.e .33 = .29 or .36 = .39

Any help would be great

Stev

 

[Frank Kabel]

Hi Steve
try
=ROUND(A1+0.01,1)-0.01

 

[steve22727]

That woeks grea