C2åå æ ¼è¾å ¥è¿ä¸ªå½æ°åï¼å¡«å ä¸å»ï¼ä½ å¯ä»¥æç §å®é æ åµåéå½ä¿®æ¹
=LOOKUP(RANK(B2,$B$2:$B$21)/COUNTA($B$2:$B$21),{0,0.4,0.7},{"A","B","C"})
追é®0,0.4,0.7,æ¯ä¸æ¯ä»£è¡¨A B Cæå ç¾åæ¯å
追çæ¯ç
=LOOKUP(RANK(B2,$B$2:$B$21)/COUNTA($B$2:$B$21),{0,0.3,0.7},{"A","B","C"})
0代表å30%
0.3代表ä¸40%
0.7代表å30%
é£{0,0.3,0.55}æ¯ä¸æ¯è¡¨ç¤º å15%ï¼ä¸30%ï¼å55% 麻ç¦äº
追çä¸æ¯