excel中销售业绩提成分段计算公式答:输入以下公式 =LOOKUP(A2,{0,1,2,3}*10^4+1,A2*{0.15,0.2,0.3,0.4}-{0,500,2500,5500})详见附图
excel提成公式答:a1=金额 b1=提成 B1栏输入公式 =A1*IF(A1<=10000,0.15,IF(A1<=15000,0.2,IF(A1<=20000,0.25,IF(A1<=25000,0.3,IF(A1<=30000,0.35,IF(A1<=40000,0.4,0.45)))
求excel表格算分段提成公式答:假如业绩X在A1单元格,分段提成公式(保留2位小数)=ROUND(IF(A1<=10000,0,IF(AND(A1>10000,A1<=20000),10000*0+(A1-10000)*0.07,IF(AND(A1>20000,A1<=30000),10000*0+10000*0.07+(A1-20000)*0.08,IF(AND(A1>30000,A1<=40000),10000*0+10000*0.07+10000*0.08+(A1-30000)*0....
excel用IF计算固定提成。答:楼上的计算有点问题,业绩不一定是多少,那么标准就应该是一个范围,用下面的数组公式比较好:=LOOKUP(A3,{10000,12000,14000,16000,18000,20000,22000,24000,26000,28000,30000},{200,240,300,350,400,500,600,700,800,900,1000})如果需要考虑<10000的情况,两个办法:=IF(D3<10000,0,LOOKUP(...