如何通过EXCEL函数计算销售提成。答:大家看清楚,别人说的是分段提成,是个超额累进的算法。=LOOKUP(A13,{0,3,4,5,6,8,10,13},A13*{5,6,7,8,9,10,12,13}%-{0,0.03,0.07,0.12,0.18,0.26,0.46,0.59})附件没办法上传,如果要的话口俺。如果是包含下限的把整数改一下,3改成3.0001,4改成4.0001,。。。依此...
EXCEL 每月阶段性提成的公式如何写答:如图,C2输入:=SUMPRODUCT(TEXT(B2-{0,20000,50000},"0;!0")*{0.35,0.05,0.05})C3输入:=SUMPRODUCT(TEXT(SUMPRODUCT((MONTH($A$2:A3)=MONTH(A3))*$B$2:B3)-{0,20000,50000},"0;!0")*{0.35,0.05,0.05})-SUMPRODUCT((MONTH($A$2:A2)=MONTH(A3))*$C$2:C2),下拉...
excel区间业绩提点计算公式,制作工资表格,需要利用分段提成进行...答:=MAX(A1*{0.03,0.045,0.055,0.06,0.07,0.08,0.09}-{0,450,1150,1750,3550,6350,10150})或 =MAX(A1*{3,4.5,5.5,6,7,8,9}%-{0,9,23,35,71,127,203}*50)