第1个回答 2011-12-02
若“期评成绩”在A1格,“等级评定标准”在B1格,输入公式:
=if(A1>=90,"优",if(A1<60,"差",if(A1>=80,"良","中")))
第2个回答 2011-12-02
=IF(A1<60,"差",IF(A1<80,"中",IF(A1<90,"良","优")))
=MID("差中良优",SUM(--(A1>={0;60;80;90})),1)
=MID("差中良优",MAX(IF(A1>={0;60;80;90},{1;2;3;4})),1)本回答被提问者采纳
第3个回答 2011-12-02
假设期评成绩在A列
B2输入公式
=IF(A2>=90,"优",IF(A2>=80,"良",IF(A2>=60,"中","差")))
下拉填充公式即可
第4个回答 2011-12-02
假设期评成绩在A列,等级在B列
B1=if(A1>=90,"优",if(A1>=80,"良",if(A1>=60,"中","差")))