If-Then Statement

[alanf]

I need help on an if then statement!

What I need to do is this...

WEIGHT COMPANY USED[/B]
5 QUICK FREIGHT
5 QUICK FREIGHT
5 QUICK FREIGHT
75 GAMECOCK FREIGHT
76 GAMECOCK FREIGHT
66 GAMECOCK FREIGHT
69 GAMECOCK FREIGHT
66 GAMECOCK FREIGHT
72 GAMECOCK FREIGHT



I NEED A STATEMENT THAT USES THIS ALSO:
*QUICK FREIGHT*
<10 $3.00 *CELL (J5
10 to 50 $20.00 cell (J6)*

GAMECOCK FREIGH
<70 $40.00 *cell (J8)*
70-90 $46.00 *cell (J9)*

So I need to create a statment that says IF its less than 5 pounds AN
uses Quick Freight, then its $3, if its 10-50 pounds AND uses Quic
Freight then its $20. I also need in the same formula to say that i
it is <70 (or 50-70?) AND uses Gamecock Freight then its $40, and i
its 70-90 pounds and uses Gamecock Freight then its $46.

How do I do this???
I cant manually do it... there are 6,800 of them..
Thanks! :

 

[Frank Kabel]

Hi
not completely sure about your conditions but use something like
=IF(AND(A1<5,B1="Quick Fright"),3,IF(AND(...))