求EXCEL销售提成阶梯计算公式答:公式为:=SUMPRODUCT(TEXT((A1-{0,5,10,15,20,25}*1000),"0;!0")*{0.05,0.01,0.01,0.01,0.01,0.01})如图所示:
如何通过Excel函数计算销售提成? 谢谢答:姓名 底薪 月售目标 月销售额 提成率 提成 月工资 甲3000 10000 50000 =LOOKUP(D2/C2,{0,0.3,1},{-0.005,0.02,0.05}) =LOOKUP(D2/C2,{0,0.3,1},{-0.005,0.02,0.05})*C2 =B2+F2 乙3000 10000 5000 =LOOKUP(D3/C3,{0,0.3,1},{-0.005,0.02,0.05}) =LOOKUP(D3/C3,{0,0.3,1},{-0.005...
销售提成excel函数公式怎么算啊答:=MIN(C2,4200)*0.12+(MIN(C2,8000)-4200)*0.13*(C2>4200)+(MIN(C2,12000)-8000)*0.14*(C2>8000)+(MAX(12000,C2)-12000)*0.15*(C2>12000)也可以用下面公式 =LOOKUP(A1,{0,4200,8000,12000},{0.12,0.13,0.14,0.15})*(A1-LOOKUP(A1,{0,4200,8000,12000}))+LOOKUP(A1,...
如何通过Excel函数计算销售提成?答:下面为公式,数组形式输入(输入公式时,同时按下CTRL+SHIFT+ENTER完成输入)姓名 底薪 月售目标 月销售额 提成率 提成 月工资 甲 3000 10000 50000 =LOOKUP(D2/C2,{0,0.3,1},{-0.005,0.02,0.05}) =LOOKUP(D2/C2,{0,0.3,1},{-0.005,0.02,0.05})*C2 =B2+F2 乙 3000 10000...