tier pricing
Using Excel, I want to look up a garmetn name in column A, then return a cost
per product from column B, C, or D, based on tier quantities purchased.
Example: In one cell(A1) I know the garment , in another cell (A2) I know
the quantity purchased.
Garment 1-23 24-49 50-100
Shirt $5 $4 $3
Pant $10 $9 $8
What formula looks up the garment shirt or pant, then returns price per item
based on second value(quantity)
|