小人斋主 发表于 2021-11-15 13:07:00

求助总分等第函数计算

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

快乐吧 发表于 2021-12-13 01:19:20

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

冯艳红 发表于 2022-1-3 09:58:38

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

用户阿杜 发表于 2022-1-23 22:50:31

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

你静姐 发表于 2022-1-30 01:50:51

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

健忘菇凉 发表于 2022-2-17 16:49:12

=LOOKUP(I99,PERCENTILE.INC($I$2:$I$480,{0,0.2,0.4,0.6,0.8}),{"e","d","c","b","a"}) 为啥总消失不见
页: [1]
查看完整版本: 求助总分等第函数计算