D4:=IF(C4<60,"不及格",IF(C4<70,"及格",IF(C4<80,"良好","优秀")))或=IF(C4="","",LOOKUP(C4,{0,60,70,80},{"不及格","及格","良好","优秀"}))下拉填充
