excel业绩提成计算公式答:=LOOKUP(A1,{0,10001,20001,30001,50001,100001,150001},{0.45,0.48,0.5,0.52,0.55,0.58,0.65})*A1-LOOKUP(A1,{0,10001,20001,30001,50001,100001,150001},{0,0,0,600,2100,5100,15600})上面的公式实现:在1-30000以内的时候,按照达到的最大计算提成等级全额计算提成(通提?);...
用Excel如何计算提成?如:本月销售额82827元,达标8万按7%计算,超出部份...答:不含4500)4500-5000提成45%(不含5000)5000以上提成50%(含5000)具体数值在A列,B列求提成数。B1输入“=IF(A1>5000,A1*50%,IF(A1>=4500,A1*45%,IF(A1>=4000,A1*40%,IF(A1>=3500,A1*35%,IF(A1>=3000,A1*30%,A1*20%)))”回车,再用填充柄将公式下拉即可。
Excel用什么公式可以实现达到某个数额,提成等于多少?答:在B2中输入或复制粘贴下列公式 =LOOKUP(A2,{0,2500,500,10000},{0,100,200,1800})或 =LOOKUP(A2,{0,2500,500,10000;0,100,200,1800})下拉填充
求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})如图所示: