# percentage markup on various price ranges

1. ## 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

2. ## Re: percentage markup on various price ranges

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.

3. ## Re: percentage markup on various price ranges

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

There are currently 1 users browsing this thread. (0 members and 1 guests)