绩效考核分数 绩效系数90 < a ≤100 1+10%*(a-90)75 ≤ a ≤90 1.065 ≤ a < 75 1-10%*(75-a)
B2=IF(A2>90,0.1*A2-8,IF(A2>=75,1,0.1*A2-6.5))
供参考,祝顺利。