excel中销售业绩提成分段计算公式答:输入以下公式 =LOOKUP(A2,{0,1,2,3}*10^4+1,A2*{0.15,0.2,0.3,0.4}-{0,500,2500,5500})详见附图
excel工资分段跳点提成函数公式?答:你算错了,10000*0.1<>800。公式为:=SUM(TEXT(A1-{0,1,2,3,4,5}*10^4,"0;!0")*{10,5,5,5,5,5}*10^-2)如图所示:
excel提成公式答:设业绩在c列,在d2输入:=if(c2<=10000,0,if(c2<=150000,c2*0.5%,75+if(c2<=500000,(c2-150000)*0.6%,210+if(c2<=800000,(c2-500000)*0.07%,210)))之前没注意比例要可调节改了一下。设比例1在e1,比例2在e2,比例3在e3单元格。在d2输入:=if(c2<=10000,0,if(c2<=150000...
求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公式:如何设置阶梯提成的算法公式答:=SUMPRODUCT(TEXT(C10-{0,1000,2000,2000,3000,2000},"0;\0")*{0,0.06,0.07,0.08,0.1,0.15})下面的:=MEDIAN(0,C16/C15,1)