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","其它")))

公式下拉