# 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

Create a table, where the first column has the LOWEST value for the markup given in the second column. For example

Lowest Value Markup
0.00 125%
5.01 110%
7.01 100%
251.00 55%

For your example of between 5.01 and 7.00 getting a markup of 110%, 7.01 gets a different markup, so it is listed in the first column.

Then use VLOOKUP in your 'other specific cell' (where you want the markup):

=VLOOKUP(Cell,Table,2,TRUE)

like

=VLOOKUP(A2,\$J:\$K,2,TRUE)

Where the cell with the price is A2 (your specific cell), the table you created is in columns J and K (with no other values)

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