Rounding Formula Question

[ChrisHockley]

Hello all,

Thanks in advance for any help you can offer.

Rounding - I'm working on some pricing and once the pricing is done I am adding a percentage to convert these prices to MSRP. This of course creates all kinds of random dollar amounts with no consistency. I need help setting up a formula that would do the following to the price (x)

a. if x is less than or equal to .11 over the nearest dollar then round down to .99 cents of the previous dollar
b. if x is .12 to .24 over the dollar round to that dollar and .19 cents
c. if x is .25 to .40 over the dollar round to that dollar and .29 cents
d. if x is .41 to .65 over the dollar round to that dollar and .49 cents
e. if x is .66 to .90 over the dollar round to that dollar and .79 cents
f. if x is .91 to .10 over the dollar round to the closest dollar and .99 cents

Wow... I just got a stress headache typing that out let alone the formula!

All I would greatly appreciate any and all attempts to assist!

Chris H.

 

[Eric W]

You're welcome again!