判定为:优秀
=if(and(sum(B2:E2)>=250,countif(B2:E2,">60")=4),"优秀","")
语文偏科
=if(and(sum(B2:E2)>=250,B2=180,"合格","不合格")
60")=4),"优秀","")语文偏科=if(and(s" property="og:description"/>
判定为:优秀
=if(and(sum(B2:E2)>=250,countif(B2:E2,">60")=4),"优秀","")
语文偏科
=if(and(sum(B2:E2)>=250,B2=180,"合格","不合格")