Round price to end in .45 or .95

To round prices to end in .45 or .95, depending on whether the original price ends above or below .50, you can use the CEILING function. In the example shown, the formula in C6 is: =CEILING(B5,0.5)-0.05 which rounds prices as shown in the screenshot. Rounding rules In the example shown, the goal is to round prices to end in either .45 or .95, following these rules: If a price is already a whole dollar, the result should be the previous whole dollar + .95. For example, $3.00 becomes $2.95. If a price ends in .50 or less, the result should be the current whole dollar + .45. For example, $4.31 becomes $4.45. If a price ends in .51 or more, the result should be the current whole dollar + .95. For example, $5.63 becomes $5.95.