问：Excel，第一个是评分标准，第二第三是我设置的，但是（当L5不合格的时候，sum〉360，良好，sum〉320，及格，不及格）这个我不知道该怎么加，黄色区域和表1是规则，谢谢大神！

大神们呢

=IF(MIN(N5,P5,R5,T5)<60,"不合格",IF(L5="合格",LOOKUP(SUM(N5,P5,R5,T5),{0,300,400,450,500,550,600},{"不及格","及格","良好","优秀","特3级","特2级","特1级"}),LOOKUP(SUM(N5,P5,R5,T5),{0,400,450,500,550,600},{"不及格","及格","良好","优秀","特3级","特2级"})))