第1个回答 2011-05-11
假设总分在l15单元格
那么,=if(l15>=450,"优秀","")
=if(AVERAGE(L5:L14)>=90,"优秀",IF(AVERAGE(L5:L14)>=80,"良好",IF(AVERAGE(L5:L14)>=70,"")))
第2个回答 2011-05-11
1.=if(sum(L5:L14)>=450,"优秀",)
2.=IF(A1>=90,"优秀",(IF(A1>=80,"优良",(IF(A1>=70,"良")))))
第3个回答 2011-05-11
1 =if(A1>=450,"优秀"," ")
2 =IF(AVERAGE(L5:L14)>90,"优秀",IF(AVERAGE(L5:L14)>80,"良好",IF(AVERAGE(L5:L14)>70,"及格"," ")))
第4个回答 2011-05-11
if(A2>=450,"优秀","")
if(L5>=90,"优秀",if(L5>=80,"良好",if(L5>=70,"及格","不及格")))