choose right price list by quantity ordered

[cath]

I am trying to build a worksheet that will show me the
cost of product we are building. If I buy 10 units of a
part I get one price, another for 25 and another for 100.
I can use the =if for two options but I am not sure how to
factor the third option into the formula.

Thanks
Cath

 

[L. Howard Kittle]

Hi Cath,

Try this.
A1 = 0
A2 = 10
A3 = 25
A4 = 100

B1 = price up to 9
B2 = price up to 24 etc., I used 10, 8, 6, 4.

In D1 enter =VLOOKUP(C1,A1:B4,2,1)
Enter the quanity to buy in C1.

108 returns 4
3 returns 10

HTH
Regards,
Howard