Excel表格公式,收回率达到100的,得1分,低于100的,由高到低排名,依次扣0.2分,扣完为止,这公式怎么设。
B4:
=MAX(0,1-(A4<100)*0.2*(RANK(A4,$A$4:$A$14)-COUNTIF($A$4:$A$14,">=100"))),下拉。