excel某单元格如果包含a或者包含b,返回“含”,都不包含返回“不含...答:=IF((FIND("a",A1&"ab")=LEN(A1)+1)*(FIND("b",A1&"ab")=LEN(A1)+2),"不含","含");或者:=IF(ISERROR(FIND("a",A1))*ISERROR(FIND("b",A1)),"不含","含")
EXCEL2003中如何统计一列中包含A字符或包含B字符的单元格总数_百度知 ...答:这个,正在考虑中……再给你考虑下……坑爹的,你看下是不是这种 =SUM(IF(IFERROR(FIND({"上海","北京"},A2:A6),"")>1,"",IFERROR(FIND({"上海","北京"},A2:A6),"")))把公式换成 =SUM(IF(IFERROR(FIND({"上海","北京"},A:A),"")>1,"",IFERROR(FIND({"上海","北京"...