=if(iserror(find("C",a1)),"","合格")或者:=if(isnumber(find("C",a1)),"合格","")
输入这个函数=IF(ISERROR(FIND("C",A1)),"","合格")回车就行了
输入这个函数=IF(ISERROR(FIND("C",A1)),"","合格")回车