percentage markup on various price ranges

I am trying to set up a pricing worksheet so that if a price of an item is entered into a specific cell, excel will look for a price range and enter that markup into another specific cell.

For example: item sells for between 5.01 and 7.00 (two different cells, one 5.01 next to it another cell with 7 then next to it markup cell of 110%;
item sells for between 251.00 and 500.00 (two different cells, one 251 next to it another cell with 500 then next to it markup cell of 55%;

So if I have 6.95 entered in my target cell, excel searches and enters 100% in my markup cell
If I have 345 entered in the same target cell, excel enters 55% in the same mark up cell.

so as the prices change the markups also change....Thanks

depending on the amount of ranges you have, you could write a a super-long IF formula, e.g. IF(start of range=>target cell<=end of range,markup,if(start of range=>target cell<=end of range,markup,if(...............

So ever ytime for the false value you start a new IF formula.


OR you make a mapping table, with all the possible ranges in one column and markups in the other column, and then perform a vlookup.