求excel销售分段提成公式,救命啊~~答:看我的抓图:=IF(B2<20000,B2*1%,IF(B2<=50000,19999*1%+(B2-19999)*3%,IF(B2<=100000,19999*1%+(50000-19999)*3%+(B2-50000)*4%,IF(B2<=200000,19999*1%+(50000-19999)*3%+(100000-50000)*4%+(B2-100000)*5%,IF(B2<=400000,19999*1%+(50000-19999)*3%+(100000-50000)*4%+...
销售额递增部分提成递增excel的计算公式?答:在B3单元格中输入公式:=IF(B1=300000,1%,IF(AND(B1>300000,B1<=400000),1.5%,IF(AND(B1>400000,B1<=500000),2%,IF(AND(B1>500000,B1<=600000),2.5%,IF(AND(B1>600000,B1<=700000),3%,IF(AND(B1>700000,B1<=800000),3.5%,4%)))如图:...
如何通过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,。。。依此...