selecting an answer based on a 3 way logic
=IF(A2="Problem A","Type A",IF(A2="Problem B","Type B",IF(AND(A2="Problem
C",B2="Yes",OR(C2={"Yes","No"})),"Type B",IF(AND(A2="Problem
C",B2="No",C2="Yes"),"Type C","undefined"))))
"Sam B" wrote:
Here is a sample of the data.
Condition 1 Condition 2 Condition 3 Type
Problem A Type A
Problem B Type B
Problem C yes no
Type B
Problem C yes yes
Type B
Problem C no yes
Type C
Based on Conditions 1, 2 and 3 I want to fill out Type A, B or C in the
forth column. So the logic would be
If condition 1 = Problem A then Type A
If condition 1 = Problem B then Type B
If condition 1 = Problem C and Condition 2=yes and condition 3 = no then
Type B
If condition 1 = Problem C and Condition 2=yes and condition 3 = yes then
Type B
If condition 1 = Problem C and Condition 2=no and condition 3 = yes then
Type C
|