xcsc.net
当前位置:首页 >> 阶梯提成方案 >>

阶梯提成方案

例:1000-5000 5%提 5001-10000 7%提 10001-15000 9%提 15001 以上10%提 一个员工销售额是20000元, (20000-15001)*10%+(15001-10001)*9%+(10001-5001)*7%+(5001-1000)*5%=4999*10%+5000*9%+5000*7%+4001*5%=499.9+450+350+200.05=1499.95 你会...

1.大多数企业对业务员的考核激励都实行提成制,按销售量提成,即按照完成销售目标的百分比,设立阶梯式提成点,这种考核激励制度都会要围绕着马斯洛的需求层次理论进行激励,这样业务员对提成高点的品种上进心要强点,那老板也赚的多点! 2.比如...

C11:=SUMPRODUCT(TEXT(C10-{1000,3000,5000,8000,10000},"0;\0")*{0.06,0.01,0.01,0.02,0.05}) C18:=MIN(C16/C15,1),设置成百分比格式。

=IF(A1>180000,(A1-180000)*0.035+40000*0.02+140000*0.007,IF(A1>140000,(A1-140000)*0.02+140000*0.007,A1*0.007)) A列为营业额。

假设销售额数据是在B2单元格开始的B列,则可以在C2单元格输入公式: =LOOKUP(B2/10^6,{0,3,8,15,30},{6,7,8,9,10}/10^4) 复制并下拉,即可得到提成比例。 提成额公式为: =B2*LOOKUP(B2/1000000,{0,3,8,15,30},{6,7,8,9,10}/10000)

输入以下公式 =1000*SUM(TEXT(B1-{1,1.1,1.2,1.3},"0.0")*{0.5,0.5,0.5,0.5}) 详见附图示例

假设本月业绩保存在A2单元格,B2单元格算提成 B2单元格公式: =if(A1

=VLOOKUP(A1,{0,0.01;100,0.02;200,0.03;300,0.04;400,0.05;500,0.06;600,0.07;700,0.08;800,0.09;900,0.1},2,TRUE) 假如数据在A1用上面的公式就可以了

设营业额为x 如果x小于50000;x就乘以2.5% 如果x大于500000小于100000; x就乘以5% 如果x大于100000;x就乘以10% 如果需要可以用网页写个小界面计算

用条件函数可以做到,但你只提供了36年的工资,其它年份的没有提供,所以不能写出具体的函数给你。

网站首页 | 网站地图
All rights reserved Powered by www.xcsc.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com