我先写一个比较直接能用的吧，=IF(ISNUMBER(A1),IF(A1>=90,"优异",IF(A1>=60,"及格","不及格")),"")
B1单元格写入公式=IF(A1="","",IF(A1<60,"不及格",IF(A1<90,"合格","优异")))或=IF(A1="","",LOOKUP(A1,{0,"不合格";60,"合格";90,"优异"}))下拉填充公式
用IF 函数
