当前位置：搜档网 › 提成Excle计算公式

提成Excle计算公式

完成额x(示例)提成分级提成计算方式

31000x<=31999x*3.5%

3200032000<=x<=35999x*4.5%

3600036000<=x<=40000x*5%

4500040001<=x<=5000040000*5%+(x-40000)*6%

5500050001<=x40000*5%+(x-40000)*10%

公式：‘

=IF(A2<=31999,A2*3.5%,IF(A2<=35999,A2*4.5%,IF(A2<=40000,A2*5%,IF(A2<=50000,(4000 0*5%+(A2-40000)*6%),IF(A2>50000,(40000*5%+(A2-40000)*10%),"错误")))))

提成y

1085

1440

1800

2300

3500 000,A2*5%,IF(A2<=50000,(4000 40000)*10%),"错误")))))

相关文档