求EXCEL中根据成绩排名(位次)赋ABCD等级。答:假设一个班的成绩放在A2:A51中, B2输入 =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如何用函数公式将B列的值按ABCDE五种条件筛选后赋值给A列单...答:公式为:=LOOKUP(B1,{"A","B","C","D","E"},{0,1,2,3,4})如图所示:
EXCEL如何给ABCD赋分值?如何求和?答:分别赋值"a","b","c","d";1,2,3,4},同理可加 =SUMPRODUCT(LOOKUP((A2:N2),{"a","b","c","d";1,2,3,4}))这样可以求和,除计数可得均分,请参考