【急求】find函数能实现多条件的查找吗?答:=IF(COUNT(FIND({"颈","肩","腿","腰","手","背"},A1)),MID(A1,MIN(IF(ISERROR(FIND({"颈","肩","腿","腰","手","背"},A1)),4^8,FIND({"颈","肩","腿","腰","手","背"},A1))),FIND("痛",A1)-MIN(IF(ISERROR(FIND({"颈","肩","腿","腰","手","...
excel FIND({"",""},)多个条件?答:=IF(SUM(1*IFERROR(FIND({"image2","image4"},A2),0))>0,"带优先级","不带优先级"),数组公式,输入结束后需要同时按下 ctrl shift enter ,效果如图 这个公式的精妙之处:iferror(find(),0),find函数在找到目标的情况下直接返回一个数据,参与求和,find函数在没有找到目标的情况下返回一...