Basic IF/AND and Nested IF/AND Statements?

[Guest]

I'd like to know how to write statements that create the following arguments:

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

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")

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")


i'm looking for syntax for the most part. However I'm also seeking to verify
that I actually CAN join separate arguments with AND or join them with OR, as
above.


Thanks

 

[Guest]

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"


---

 

[Guest]

Oops, typo for H1, missing closing parens

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

---