帮忙 设计一个excel表格 销售业绩分段提成 公式,谢谢答: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<=80000),10000*.2+10000*.22+20000*.25+20000*.3+(a1-60000)*.35),...