Categorise Data Based on Combination of Variables

[adamuce]

[/IMG] I have two questions so will ask them 1 after the other, in regards to the table below


Easier one first


I want to categorise Trucks by their tanks and the 3 categories are in Type 1 column:

No SS: SS column: "No" + "Yes" in any columns X1 to X3
SS Only: SS column: "Yes" + "No" in all columns X1 to X3
Partial SS: SS column: "Yes" +"Yes" in any of X1-X3


Im assuming the formula to be used is an IF and AND.

 

[eibi]

Welcome to the forum!

See attached, using this formula:

=IF(B3="Yes",IF(COUNTIF(C3:E3,"No")=3,"SS Only",IF(COUNTIF(C3:E3,"Yes")>0,"Partial SS")),IF(COUNTIF(C3:E3,"Yes")>0,"No SS"))