请问Excel计算工资提成绩效公式怎么写?各位高手支支招,谢谢!_百度知...答:B2开始的B列就是对应的提成比率,在C2单元格输入公式:=A2*LOOKUP(A2-1%%,{0,9999,30000,50000,80000,100000,120000,150000,180000,210000,230000},{0,0.04,0.06,0.08,0.1,0.12,0.14,0.16,0.18,0.2,0.22})复制并下拉,所得就是A2开始每一个业绩核算出来的提成绩效金额了。
怎么用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})