excel如果A1单元格包含某符号时B1单元格则显示为合格

2024-11-15 05:43:54
推荐回答(3个)
回答1:

=if(iserror(find("C",a1)),"","合格")

或者:
=if(isnumber(find("C",a1)),"合格","")

回答2:

输入这个函数=IF(ISERROR(FIND("C",A1)),"","合格")回车就行了

回答3:

输入这个函数=IF(ISERROR(FIND("C",A1)),"","合格")回车