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
Bookmarks