Formula help

[neil_stafford]

Hi All,

im tearing my hair out here, seems so simple but i cant get my hea
around it!!!!

for example i want the following to calculate

i have a part number, then a quantity (both in different cells) but
in the third cell i want to calculate if the quantity of part pml2 i
less than 5 then there is one price but if more than 5 another pric
and if more than 10, yet another price!

I have some 200 parts to calculate like this & its driving me NUTS t
work out the formula!!!!!

Hope ive explained this ok!, and if anyone can help it would be greatl
appreciated!

Many Thanks & Kind Regards

Nei

 

[Frank Kabel]

Hi
I would setup a separate table with your pricing. e.g. the
table 'price with something like
A - B
0 1.00
6 0.90
10 0.87
....

Now on your second sheet if A1 contains the quantity use
=VLOOKUP(A1,'price'!$A$1:$B$10,2,0) to get the respective
price for this quantity