excel中,如何根据排名计算得分?答:C2直接粘贴公式 =IF(B2=MIN($B$2:$B$17),4,IF(B2=MAX($B$2:$B$17),1.6,(4*0.4+(4-1.6)*(INDIRECT("A"&MATCH(B2,B:B,0))-INDIRECT("A"&MATCH(MAX($B$2:$B$17),$B:$B,0)))/(INDIRECT("A"&MATCH(MIN($B$2:$B$17),$B:$B,0))-INDIRECT("A"&MATCH(MAX(...
求助 根据排名范围内得分,如何编辑EXCEL公式?答:假设A列是排名(1-130),先添加个B列(B=131-A),C列设置公式:=LOOKUP(PERCENTRANK($A$1:$A$130,A1,2),{0,0.1,0.4,0.7,0.9,1},{6,12,18,24,30})