excel if计算多级提成 举例: 0——10000销售额提成10% 10001——20000...答:=if(AND(A1>0,A1<=10000),10%,if(A1<=20000,20%,if(A1<=30000,30%,if(A1<=40000,35%,if(A1<=50000,40%,"没有定义")))
帮忙 设计一个excel表格 销售业绩分段提成 公式,谢谢答:=if(and(a1>=1,a1<=10000),a1*.2,if(and(a1>=10001,a1<=20000),10000*.2+(a1-10000)*.22),if(and(a1>=20001,a1<=40000),10000*.2+10000*.22+(a1-20000)*.25),if(and(a1>=40001,a1<=60000),10000*.2+10000*.22+20000*.25+(a1-40000)*.3),if(and(a1>=60001,a1<=...
excel中销售业绩提成分段计算公式答:输入以下公式 =LOOKUP(A2,{0,1,2,3}*10^4+1,A2*{0.15,0.2,0.3,0.4}-{0,500,2500,5500})详见附图