正序排名 X≤5名,不扣分; 排名在X、Y之间的,每差5%名扣0.2分; 倒序排名...答:倒排序:RANK(A1,$A$1:$A$24,1);=IF(AND(RANK(A1,$A$1:$A$24,0)>5,RANK(A1,$A$1:$A$24,1)>5),A1-(RANK(A1,$A$1:$A$24,0)-5)/0.05*0.2,(IF(RANK(A1,$A$1:$A$24)<=5,A1,(IF(RANK(A1,$A$1:$A$24,1)<=5,0)))你可以填入数据在excel表中试验...