Nested IF OR AND string
I am looking to combine 2 variables supported by an AND statement to look for matches and then result in an output
- Owner (output on match)
=IF(OR([::IMPACTED REGION(S)]@row = "US", [::IMPACTED REGION(S)]@row = "CAD", AND([::IMPACTED FUNCTIONAL AREA(S)]@row = "Insurance", [::IMPACTED FUNCTIONAL AREA(S)]@row = "Sales"), [=IMPACTED & RESPONSIBLE RISK OWNER(S)]@row, "NoName"))
I want to look for REGION name US or CAD and the AREA name Insurance or Sales. if either US or CAD are in the REGION field AND if either Insurance or Sales are in the AREA Field, an Owner named cell out be the match.
How close or far am i from getting this right? I am getting ? I get Unparsed Error or Incorrect Argument right now.
Help Article Resources
Check out the Formula Handbook template!