笨的方法=SUM(A1>PERCENTILE.INC($A$1:$A$20,20%),A1>PERCENTILE.INC($A$1:$A$20,40%),A1>PERCENTILE.INC($A$1:$A$20,60%),A1>PERCENTILE.INC($A$1:$A$20,80%))+1
应该有聪明的方法用Matrix公式把条件写成1段
用最笨的IF多套几层就好了吧
=IF(RANK(A1,A:A)<ROUND(COUNT(A:A)/5,0),"优",IF(RANK(A1,A:A)<2*ROUND(COUNT(A:A)/5,0),"良+",IF(RANK(A1,A:A)<3*ROUND(COUNT(A:A)/5,0),"良",IF(RANK(A1,A:A)<4*ROUND(COUNT(A:A)/5,0),"中","差"))))
Huasing Association 1999 - 2013