Hello,

I am looking for a formula that will select the appropriate mark up based on the purchase price I enter.

Mark Up:
<.49= 600%
.49-.99= 550%
1.00-1.99= 525%

I would like to be able to enter a price and have the formula select the mark up automatically. If I enter Widget A as having a price of $0.54, it will select the 550% mark up and apply it appropriately.

Any ideas?