I am working on a spreadsheet that needs to calculate cost which is dependent on the total number of items ordered. This information is in a cell of its own. This sheet has over 100 total items on it and I believe this formula, if it exists, will need to be applied to each product line.

Product 1-12 pcs 13-25 pcs 26-50 pcs 51+ pcs
1234 6.25 6.10 6.00 5.75

Thank you very much for your time.
PlayVideo: YES

---

Reply from Richard Rost:

You would use a VLOOKUP function to look up the price based on the quantity entered.