假如学生姓名存在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))
二、分数大于等于150的0.9（135分及其以上）为A，小于150的0.9大于等于150的0.8（120分到134分）的为B，小于150的0.8大于等于150的0.6（90分到119分）的为C，小于150的0.6（89分及其以下）的为D，将等次填入J列。
有几个公式可以实现，下面只给出J3的公式，其他下拉即可。
=LOOKUP(G3,150*{0,0.6,0.8,0.9},{"D","C","B","A"})
=VLOOKUP(G3,{0,"D";90,"C";120,"B";135,"A"},2)
=HLOOKUP(G3,{0,90,120,135;"D","C","B","A"},2)
=CHOOSE(MATCH(G3,150*{0,0.6,0.8,0.9}),"D","C","B","A")
=HLOOKUP(G3,CHOOSE({1;2},{0,90,120,135},{"D","C","B","A"}),2)
=IF(G3>=135,"优",IF(G3>=120,"好",IF(G3>=60,"中","差")))