Excel应用_给成绩按比例划分ABCD等的几种方法

        假如学生姓名存在a3:a762中，某科成绩存在g3:g762中，满分150分，四个等次的划分有两种分法：

        一、分数从高到低算，总人数的第一个四分之一为A，第二个四分之一为B，第三个四分之一为C，第四个四分之一为D，将等次填入到H列。

          有几个公式可以实现，下面只给出H3的公式，其他下拉即可。

          =LOOKUP(RANK(G3,G$3:G$762),COUNT($G:$G)*{0,0.25,0.5,0.75}+1,{"A","B","C","D"})

          =CHOOSE(MATCH(RANK(G3,G$3:G$762),COUNT($G:$G)*{0,0.25,0.5,0.75}+1),"A","B","C","D")

          =HLOOKUP(PERCENTRANK($G$3:$G$762,G3,2),{0,0.25,0.5,0.75;"D","C","B","A"},2)

          =IF(G3>PERCENTILE($G$3:$G$762,0.75),"A",IF(G3>PERCENTILE($G$3:$G$762,0.5),"B",IF(G3>PERCENTILE($G$3:$G$762,0.25),"C","D")))

          =CHAR(64+MATCH(RANK(G3,G$3:G$762),COUNT($G:$G)*{0,0.25,0.5,0.75}+1))