发布网友 发布时间:2022-11-30 20:27
共1个回答
热心网友 时间:2023-11-05 06:53
假设是判断excelA1单元格内是否含有"#"号字符,则\x0d\x0a另一单元格写入公式\x0d\x0a=IF(COUNT(FIND("#",A1)),"包含","不包含")\x0d\x0a或\x0d\x0a=IF(COUNTIF(A1,"*#*"),"包含","不包含")\x0d\x0a再或\x0d\x0a=IF(ISERROR(FIND("#",A1)),"不包含","包含")\x0d\x0a\x0d\x0a=IF(ISNUMBER(FIND("#",A1)),"包含","不包含")\x0d\x0a\x0d\x0a=IF(ISNA(MATCH("*#*",A1,)),"不包含","包含")\x0d\x0a\x0d\x0a=IF(ISNA(VLOOKUP("*#*",A1,1,)),"不包含","包含")