How Can I Round Prices to the nearest 0.95 with an Excel Formula?

I need to round up all my prices to the nearest $0.95. For instance I have 23.106 and 102.58888. They would need to be rounded off to $22.95 and $102.95. How can I do this with an excel formula/function?

>Solution :

Try: =ROUND(C3,0)-0.05

Replace C3 with the value in a cell like your example.