selecting an answer based on a 3 way logic

S

Sam B

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

T

Teethless mama

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

S

Sam B

Thank you for the quick reply. I tried this and I get "undefined" for the
last three rows, instead of Type B, Type B, Type C

S

Sam B

Found the problem. It was a typo. Thank you.

Teethless mama said:
=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"))))