I am using SharePoint 2010.
I added a new Column and made it a Calculated Column.
Now I need to place a CASE statement in my Formula. Something like this...
CASE when [Region1] = 'A' and [Region2] = 'B' THEN 'NO' when [Region1] = 'C' and [Region2] = 'D' THEN 'YES' else 'N/A' END
So the value of my Calculated Column will be either YES or NO