IIF Condition with 3 options

[willrans]

Please help... I am trying to get the following results. If the Qty is less than 99 bag 10 per, if the qty is between 100 and 999 bag 100 per and if the qty is greater than 999 bag 200 per.

Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]>99,"100 PER",IIf([QTY]>999,"200 PER"))))

I am only getting the results of "10 PER" AND "100 PER". How do I get the results I want?

 

[Rich]

Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]>99<999,"100 PER","200 PER")))

 

[willrans]

Thank you very much for the quick reply, but I am still not getting the result of when the qty is greater than 1000 to return "200 PER".

 

[Bhaughbb]

How about-
Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]>999,"200 PER","100 PER")))

test for below the minimum, above the maximum and the rest falls in between?

 

[Rich]

oops, Alcohol
Pkg Qty: IIf([QTY]<=99,"10 PER",(IIf([QTY]<999,"100 PER","200 PER")))

 

[willrans]

Thank you so very much!!!!!!!!!!!!!!!!!! Both formulas work well!!!