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

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?

CodePudding user response：

Try this:

 =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING(A3,1) 1,CEILING(A3,1))-0.05

If the decimal is greater than .95 or is a whole number (no decimals), it will add add 1 to the number and then use the CEILING function to round the number up and then subtract .05.

1.52 = 1.95
2.00 = 2.95
66.98 = 67.95

CodePudding user response：

Try: =ROUND(C3,0)-0.05

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