EXCEL阶梯提成?答:=IF(A1<=3000,0,IF(A1<=10000,0.03%,IF(A1<=30000,0.05%,0.08%)))公式意思是:如果A1<=3000,那么返回0,如果A1<=10000,那么返回0.03%,如果A1<=30000,那么返回0.05%,否则(不满足前面所有条件时),返回0.08 或者公式为:=IF(A1>30000,0.08%,IF(A1>10000,0.05%,IF(A1>3...
excel阶梯提成计算公式答:提成额公式为:=B2*LOOKUP(B2/1000000,{0,3,8,15,30},{6,7,8,9,10}/10000)
求阶梯式业绩提成算法公式答:=IF(A2>=40000,A2*40%,IF(A2>=30000,A2*35%,IF(A2>=200000,A2*30%,IF(A2>=10000,A2*25%,IF(A2>=5000,A2*20%,“”)))假设销售额在A1单元格,则公式为:=IF(A1<15000,A1*0.03,IF(A1<22500,750+(A1-15000)*0.08,1350+(A1-22500)*0.1))如果业绩为30万,在A2单元格,那么...
求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表格的IF函数公式设置,阶梯式答:(这个表可以根据你的实际提成阶梯自行维护)C2输入公式:=IF(AND(A2>0.7,B2>0),VLOOKUP(B2,$G$2:$I$10,3,1)+(B2-VLOOKUP(B2,$G$2:$I$10,1,1))*VLOOKUP(B2,$G$2:$I$10,2,1),0)可得到满足条件的超额提成总比例。再加上你的基础提成比例,就是总的提成了 附件请参考 ...
求用Excel公式,计算阶梯式提成答:建议参照如下:在J4单元格中输入公式:=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级")))如图: