Question

在excel中怎样用公式表示S4单元格中如果包含字符"A"，则返回值"A"。如果包含字符"B"，则返回值"B

Answer 1

=IF(ISNUMBER(FIND("A",S4)),"A",IF(ISNUMBER(FIND("B",S4)),"B",""))

如果条件多，需要其他函数

Answer 2

公式：
=IF(COUNT(FIND("A",S4)),"A",IF(COUNT(FIND("B",S4)),"B",""))

或：
=IF(ISNUMBER(FIND("A",S4)),"A",IF(ISNUMBER(FIND("B",S4)),"B",""))

或：
=IF(COUNT(SEARCH("A",S4)),"A",IF(COUNT(SEARCH("B",S4)),"B",""))

或：
=IF(ISNUMBER(SEARCH("A",S4)),"A",IF(ISNUMBER(SEARCH("B",S4)),"B",""))

追问

如果套嵌超过7个呢？

追答

那共有多少个呢？公式修改为这样，支持A-Z共26个。

=IF(S4="","",LOOKUP(1,0/ISNUMBER(FIND(CHAR(ROW($65:$90)),S4)),CHAR(ROW($65:$90))))

Answer 3

用公式：
=IF(ISNUMBER(FIND("A",S4)),"A","")&IF(ISNUMBER(FIND("B",S4)),"B","")