excel跳点提成公式怎么做呢?答:则计算单元格写入公式 =IF(B2="","",LOOKUP(B2,{0,"有底薪";1001,0.2;10001,0.25;15001,0.3;20001,0.35;25001,0.4;30001,0.45;40001,0.5}))如果是要计算出底薪+佣金,则公式为 =IF(B2="","",底薪所在单元格+B2*LOOKUP(B2,{0,0;1001,0.2;10001,0.25;15001,0.3;20001,0...
这个怎么用表格公式计算对应提成?答:建议参照如下:在J4单元格中输入公式:=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级")))如图:
...算出业务员的提成 比如1-2000提成10% 在表格里面怎么算答:5000(含)以上提成15%。在EXCEL表中,再假设业务数据在B列的B2单元开始,则在C2单元输入公式:=B2*LOOKUP(B2,{0,2000,5000},{0.1,0.12,0.15})或者是:=B2*LOOKUP(B2,{0,2000,5000},{10,12,15}*1%)复制下拉,即可得到B列相关业务的提成了。具体数据你可以根据要求进行调整的 ...
excel表格做提成计算答:设销售额在A2,提成在B2,请在B2输入公式:=IF(A1<13485,A1*8%+100,IF(A1<22475,A1*10%+200,IF(A1<34162,A1*12%+300,IF(A1<43152,A1*14%+400,IF(A1<53940,A1*15%+500,A1*15%+500)))