excel单元格包含某特定文字,则输出是某种内容,如何做公式?答:=IF(AND(OR(ISNUMBER(FIND(D$2:D$4,A2))),OR(ISNUMBER(FIND(D$5:D$6,A2))),"都有",IF(OR(ISNUMBER(FIND(D$2:D$4,A2))),"人物",IF(OR(ISNUMBER(FIND(D$5:D$6,A2))),"动物","")))或 =IFS(AND(OR(ISNUMBER(FIND(D$2:D$4,A2))),OR(ISNUMBER(FIND(D$5:D$6,A2)...
Excel里,查找某个单元格内容,如果有特定字符则输出特定值?答:=IF(AND(ISNUMBER(FIND("A",A1,1)),NOT(ISNUMBER(FIND("B",A1,1))),1,IF(AND(ISNUMBER(FIND("B",A1,1)),NOT(ISNUMBER(FIND("A",A1,1))),2,IF(AND(ISNUMBER(FIND("A",A1,1)),ISNUMBER(FIND("B",A1,1))),8,IF(AND(NOT(ISNUMBER(FIND("A",A1,1))),NOT(ISNUMBER(FIND(...
如果一个单元格包含“a”或“b”或“c”中任意一个,即输出“正确”,否...答:这个有好多种写法:=if((a1="a")*(a1="b")*(a1="c"),"正确","错误")=if(a1="a","正确",if(a1="b","正确",if(a1="c","正确","错误")))=IF(OR(A1={"a","b","c"}),"正确","错误")=if(or((a1="a"),(a1="b"),(a1="c")),"正确","错误")...