H3=LOOKUP(G3,{0;60;80},{"不合格";"合格";"优秀"})
或者=IF(G3<60,"不合格",IF(G3<80,"合格","优秀"))
向下复制
C13=MAX(F:F)
C14=MIN(F:F)