如果单元格包含某字段,则显示为有,多个条件?答:=IF(COUNTIF(A1,"*一班*"),"周老师",IF(COUNTIF(A1,"*二班*"),"方老师",IF(COUNTIF(A1,"*三班*"),"王老师","")))或者 =IFERROR(LOOKUP(MATCH(1=1,ISNUMBER(FIND({"一班","二班","三班"},A1)),),{1,2,3},{"周老师","方老师","王老师"}),"")如须添加如图格式 ...
Excel中判断右边的全部字段字符,包含在左边里答:I3输入 =IF(ISERR(FIND(H3,F3)),"","包含")回车并向下填充。你的赏分不少,再给你几道公式吧:之前的叫”反推法“。还有:=IF(COUNT(FIND(H3,F3)),"包含","")——”计数法“=IF(ISERR(SEARCH(H3,F3)),"","包含")——”反推法“=IF(COUNTIF(F3,"*"&H3&"*"),"包含","")—...