excel中怎样使用IF函数评定员工的考核等级答:如果考核分数在B2单元格,那么输入 =LOOKUP(B2,{0,60,70,80,90},{"不及格","及格","一般","良好","优"})
EXCEL问题答:假定"平均分"在F列,第一行为表头,评定等级公式:=LOOKUP(F2,{0,60,70,85;"不及格","及格","良好","优秀"})假定"解剖"成绩在D2:D100区域,选定某空白列的6个单元格,输入公式:=FREQUENCY($D$2:$D$100,{100,99,89,79,69})按CTRL+SHIFT+回车....
用excel评定成绩等级,该怎么做?IF函数只能嵌套7层,可我需要评11个,该...答:分数在A1,评级在B1=IF(A1="","",LOOKUP(A1,{0,60,62,66,71,75,78,82,85,90;"F","D","C-","C","C+","B-","B","B+","A-","A"}))
用excel做等级评定,条件如图,语句怎么写?答:数组公式:=IF(AND(C2="A",K2="A",MAX(CODE(D2:J2))<67,SUM(CODE(D2:J2))<=(5*65+66*2)),"A",IF(AND(MIN(CODE(C2:J2))<67,K2="A"),"B","C"))数组公式,输入后需要按住ctrl+shift,回车