怎么用EXCEL算绩效工资?答:公式如下:=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})
如何计算绩效工资?答:奖金:与组织整体绩效关联,可以按季度发放,建议奖金从净利润中支取,人均不要低于1000。问题五:EXCEL中绩效工资的具体计算方法如何设立公式 B3是完成率,C3写公式:=LOOKUP(B3*100,{0,69,79,87,93,98,101,105,110,120},{0.7,0.79,0.87,0.92,0.98,1.01,1.05,1.1,1.15,1.2})...