怎么用EXCEL算绩效工资？

Question

怎么用EXCEL算绩效工资？比如小张绩效分为105分，则绩效工资应为工资的110%， 小王81分，则绩效工资应为工资的90%.......，谢谢大神，应该用什么公式。

Answer 1

公式如下：

=LOOKUP(A1,{50,60,65,75,80,85,90,95,100,105,110,1000;0,0.4,0.6,0.75,0.8,0.9,0.95,1,1.05,1.1,1.15,1.2})

Answer 2

用 lookup 函数，在绩效工资栏里输入公式
=LOOKUP(B10,{0,50,60,65,75,80,85,90,95,100,105,110,200},{"0","40%","60%","75%","80%","90%","95%","100%","105%","110%","115%","120%"})
其中B10是我试验表的位置，你可以改成相应的单元格位置本回答被提问者和网友采纳

Answer 3

用if函数可以解决