EXCEL或WPS的函数中 多条件查找包含某个字符的判断怎么写呢答:公式设置运行效果如下:D2单元格输入公式:=IF(AND(IF(ISNUMBER(FIND("义务",C2)),1,0)=1,COUNTIFS($A$2:$A$7,A2,$B$2:$B$7,"初中")>=1),"准确",IF(AND(IF(ISNUMBER(FIND("义务",C2)),1,0)=0,COUNTIFS($A$2:$A$7,A2,$B$2:$B$7,"初中")>=1),"错误",IF(AND(IF...
excel单元格包含某特定文字,则输出是某种内容,如何做公式?答: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))),"都有",OR(ISNUMBER(FIND(D$2:D$4,A2))),"人物",OR(ISNUMBER(FIND(D$5:D$6,A2))),"动物",1,"")下拉填充 ...