Help with a simple formula

[tLouk]

I THINK what I want is pretty simple I just can't find anywhere that will help me.

If Column A is over $10 it will have an order qty of 3
BUT If Column A is $20 it will have an order qty of 2
BUT If Column A is over $50 it will have an order qty of 1

So I want excel to be able to distinguish the 3 or 4 levels of pricing and work out that if it is within a certain threshold then it equals a certain order qty.

help?

[sambit]

Hi,
Assume order Qty. coloum is B

Try:
=IF(AND(A:A>10,A:A<=20),3,IF(AND(A:A>20,A:A<=50),2,IF(A:A>50,1,0)))

copied down

[sonjiab]

=if(a1>50,1,if(a1=20,2,if(a1>10,3)))