求EXCEL中根据成绩排名(位次)赋ABCD等级。答:=LOOKUP(PERCENTRANK(A$2:A$51,A2),{0,0.1,0.3,0.75},{"D","C","B","A"})下拉。PERCENTRANK是用来计算百分比排位的函数,最差为0,最好为1,用它的结果在数组{0,0.1,0.3,0.75}中模糊查找,返回对应...
在Excel里怎样对学生成绩按分数段定ABCD等答:设学生的成绩从A1单元格开始,成绩分等的从B1单元格开始,则在B1单元格复制以下公式:=IF(A1>=90,"A",IF(AND(A1>=80,A1<90),"B",IF(AND(A1>=70,A1<80),"C",IF(AND(A1>=60,A1<70),"D","E")))然...