怎么用Excel做下边的公式？

推荐回答

C2输入：=IF(AND(B2<>MAX($B$2:$B$18),B2<>MIN($B$2:$B$18)),B2,IF(OR(B2/LARGE($B$2:$B$18,2)>=1.15,B2/SMALL($B$2:$B$18,2)<=0.85),"",B2)) 下拉填充公式

C20输入：

=IF(COUNT(C2:C18)>5,(SUM(C2:C18)-MAX(C2:C18)-MIN(C2:C18))/(COUNT(C2:C18)-2),AVERAGE(C2:C18))

D2输入：

=IF(C2="","",40-ABS(100*(C2-$C$20)/$C$20))  下拉填充公式