exlcel表格分段提成计算方式答:公式:=MIN(10000,A2)*1%+MIN(5000,MAX(0,A2-10000))*1.2%+MIN(5000,MAX(0,A2-15000))*1.3%+MIN(5000,MAX(0,A2-20000))*1.4%+MIN(5000,MAX(0,A2-25000))*1.4%+MAX(0,A2-30000)*1.5 示例:介绍:MIN表示最高多少的部分,MIN(10000,A2)*1%表示10000以下的部分,MIN(5000,...
如何通过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表格来自动计算,用什么函数可以达到目 ...答:=IF((DATEDIF(A1,NOW(),"m")=0),B1*10%,IF((DATEDIF(A1,NOW(),"m")=1),B1*8%,IF((DATEDIF(A1,NOW(),"m")=3),B1*6%,IF((DATEDIF(A1,NOW(),"m")=4),B1*4%,IF((DATEDIF(A1,NOW(),"m")>1)