Question

EXCEL IF函数 ，如何设置一行数据中全为A ，则为A；如果含有B，则为B，如果含有C，则为C

例如：
A A A →A
A B A →B
A A C →C
A B C →C

Answer 1

=IF(COUNTIF(A1:C1,"C"埋做),"C",IF(COUNTIF(A1:C1,"B"吵返),"B",IF(COUNTIF(A1:C1,"A")=3,"A"升液饥,"")))

Answer 2

见截图

B2输入

=IF(SUBSTITUTE(A2,"A","")="","A",IF(ISNUMBER(FIND("C",A2)),"C",IF(ISNUMBER(FIND("B",A2)),"B"轮虚迹,"其它")))

公式下拉腊并誉歼