Basic IF/AND ---- Example: IF A1 = "KG" and B1 = "LB", then C1=2.205, IF
NOT, then C1 is ""

In C1:
=IF(AND(A1="KG",B1="LB"),2.205,"")

Nested IF/AND with an AND condition in the join ---- Example: ( IF A1 =
"KG" AND B1 = "LB ) AND (IF E1 = "GBP" AND F1 = "PER DAY") then G1=
"EVALUATE"; IF NOT THEN G1= "DROP")

In G1:
=IF(AND(A1="KG",B1="LB",E1="GBP",F1="PER DAY"),"EVALUATE","DROP")

Nested IF/AND with an "OR" condition in the join ---- Example: ( IF A1 =
"KG" AND B1 = "LB ) OR (IF E1 = "GBP" AND F1 = "PER DAY") then H1= "FLAG FOR
HQ"; IF NEITHER IS TRUE, THEN H1= "LOST BUSINESS")

In H1:
=IF(OR(AND(A1="KG",B1="LB"),AND(E1="GBP",F1="PER DAY")),"FLAG FOR HQ","LOST
BUSINESS"

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---