求助总分等第函数计算

小人斋主

总分前20%为A，中间20%为B，20%为C，20%为D，20%为E，怎么用函数可以直接得出？

总分前20%为A，中间20%为B，20%为C，20%为D，20%为E，怎么用函数可以直接得出？.rar (29.33 KB, 下载次数: 14)

2021-11-15 13:07 上传

点击文件名下载附件
总分前20%为A，中间20%为B，20%为C，20%为D，20%为E，怎么用函数可以直接得出？.rar

快乐吧

=LOOKUP(RANK(I2,$I$2:$I$481,0)/480,{0,20,40,60,80}%,{"A","B","C","D","E"})

冯艳红

=MID("ABCDE",MATCH(1=1,PERCENTILE(I$2:I$481,{8,6,4,2,0}*0.1)<=I2,),1)

用户阿杜

=LOOKUP(I456,PERCENTILE.INC($I$2:$I$480,{0,0.2,0.4,0.6,0.8}),{"e","d","c","b","a"})

你静姐

=LOOKUP(I456,PERCENTILE.INC($I$2:$I$480,{0,0.2,0.4,0.6,0.8}),{"e","d","c","b","a"})

健忘菇凉

=LOOKUP(I99,PERCENTILE.INC($I$2:$I$480,{0,0.2,0.4,0.6,0.8}),{"e","d","c","b","a"}) 为啥总消失不见