如果及格率在B2单元格,输入以下公式
=9-IF(B2<90%,MIN(INT((0.9-B2)*100)*0.5,4),0)
=IF(AND(COLUMN()=4,$C2>=90%),9,IF(AND(COLUMN()=5,$C2<90%),$C2-1%,$B2-0.5))
如果及格率在G2单元格,那么输入以下公式
=9-IF(G2<0.85,MIN(INT((0.85-G2)*100)*0.5,4),0)
详见附图
=IF(A1="","",MAX(4,9-IF(A1>=0.9,0,(0.9-A1)*0.5)))
=IF(A1*100>90,9,IF(90-A1*100>9,5,9-(90-A1*100)*0.5))