Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic IF/AND and Nested IF/AND Statements?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic IF/AND and Nested IF/AND Statements?
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 --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic IF/AND and Nested IF/AND Statements?
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") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF statements | Excel Worksheet Functions | |||
nested if statements | Excel Discussion (Misc queries) | |||
nested if statements | Excel Worksheet Functions | |||
Nested If/Then statements | Excel Worksheet Functions | |||
I want to use more than 7 nested if then statements | Excel Worksheet Functions |