请问Excel计算工资提成绩效公式怎么写?各位高手支支招,谢谢!_百度知...答:在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})
EXCEL中绩效工资的具体计算方法如何设立公式答:C1是基本工资,D1是最终的工资 写公式如下:B1中输入公式 =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})D1中输入公式 =B1*C1 依次输入A1,和C1的基本数据,D1即可自动算出总工资。
(急)想在excel设置公式。求教。公司算工资有一部分是绩效工资,按评分算...答:假设你的评分是A列,将B列设公式为下式即可,直接计算出绩效工资 =IF(A1>95,2,IF(A1>89,1.5,IF(A1>79,1,IF(A1>69,0.8,IF(A1>59,0.6,0.4)))*1000