If-Then Statement

[alanf]

Weight is in *Column B*, and Company Used is in *Column D*



I tried the formula, copied it down and everything says FALSE, not
number...

This is the formula I have in there right now...

=IF(AND(B1<5,D1="Quick Freight"),3,IF(AND(B1>10<50,D1="Quic
Freight"),20,IF(AND(B1>50<70,D1="Gamecoc
Freight"),40,IF(AND(B1>70<90,D1="Gamecock Freight"),46))))

:confused

 

[Domenic]

Assuming that your data is contained in Columns A and B, and that you
data starts in the second row...

Set up two tables and define a name for both, something like this...

For Quick Freight....

0.....$3.00
10.....$20.00
51.....Weight Not Allowed

...and name the table QuickFreight [Insert > Name > Define].

For Gamecock Freight...

0.....$40.00
70.....$46.00
91.....Weight Not Allowed

...and name the table GamecockFreight [Insert > Name > Define].

I assumed that weights are not allowed in excess of the weights you'v
specificed. If needed, adjust the tables accordingly.

Then, enter the following formula in C2 and copy down:

=VLOOKUP(A2,CHOOSE(MATCH(B2,{"Quick Freight","Gamecoc
Freight"},0),QuickFreight,GamecockFreight),2)

Hope this helps