EXCEL if函数 如果包含 则为 不包含则为?答:=IF(OR(IFERROR(FIND("厦门",A2),0)<>0,IFERROR(FIND("漳州",A2),0)<>0,IFERROR(FIND("泉州",A2),0)<>0,IFERROR(FIND("龙岩",A2),0)<>0),"厦门","福州")或者用简单点的函数IF OR组合 =IF(OR(B2="厦门",B2="龙岩",B2="漳州",B2="泉州"),"厦门","福州")...
excel单元格包含某特定文字,则输出是某种内容,如何做公式?答:在B2中输入或复制粘贴下列公式 =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(...