excel公式计算工资提成方法?答:E2公式:=LOOKUP(D2,{0,0.1,0.2,0.3,0.4,0.5,0.65},{0,1,2,3,4,5,8}%)*B2 下拉复制公式。
求excel表格算分段提成公式答:假如业绩X在A1单元格,分段提成公式(保留2位小数)=ROUND(IF(A1<=10000,0,IF(AND(A1>10000,A1<=20000),10000*0+(A1-10000)*0.07,IF(AND(A1>20000,A1<=30000),10000*0+10000*0.07+(A1-20000)*0.08,IF(AND(A1>30000,A1<=40000),10000*0+10000*0.07+10000*0.08+(A1-30000)*0....
excel表格怎么做提成计算??答:建议参照如下:在J4单元格中输入公式:=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级")))如图:
如何根据销售业绩算提成要excel表格形式?3万以下不提成含;满3万的...答:假设数据在A1 在B1中输入或复制粘贴此公式 提成比例 =IF(A1="","",LOOKUP(A1,{0,30000,40000,60001},{0,1,2,5}%))提成数量 =IF(A1="","",LOOKUP(A1,{0,30000,40000,60001},{0,1,2,5}%)*A1)下拉填充