那么G3单元输入： =IF(L3<1%,-1,IF(L3<=87%,0,IF(L3>=95%,8,L3*100-87)))
G3里的公式如下=MAX(MIN(8-(0.95-L3)*100,8),0)
=IF(J3/K3<=0.87,0,8-IF(J3/K3>=0.95,0,J3/K3*100-95))
