excel提成公式,2万业绩以内按2%,2-10万按4%,10万以上按6%
按照你的描述,公式就是:
=A2*LOOKUP(A2,{0,0.02;20000,0.04;100000,0.06})
如果实际情况是:
2-10万范围是按4%,10万以上部分按6%,则公式为:
=A2*0.02+MAX(0,A2-20000)*(0.04-0.02)+MAX(0,A2-100000)*(0.06-0.04)
=IF(A1<20000,2,IF((A1<=100000,4,6))%*A1
=lookup((A1-1)/10000,{0,2,10},{2,4,6})%*A1
=IF(A1<20000,A1*2%,IF((A1>=20000)*(A1<=100000),A1*4%,A1*6%))
上一篇:辞退以后什么时候结算工资
热门标签: