如果这三个条件满足一个就行了的话，用IF和OR就行了 =IF(OR(A1="优秀",A1="完美",A1="上等"),A,"")
第二个单元格输入=IF(OR(A1="优秀",A1="完美",A1="上等"),"A","")
