excel 计算提成比例答:假如目标值在A1 完成值在A2,B2=IF(A2<=A1,15%,IF((A2>10%)*(A2<20%),20%,IF((A2>20%)*(A2<25%),25%,IF((A2>25%)*(A2<40%),30%,IF(A2>50%,50%)))
excel表格做提成计算答:设销售额在A2,提成在B2,请在B2输入公式:=IF(A1<13485,A1*8%+100,IF(A1<22475,A1*10%+200,IF(A1<34162,A1*12%+300,IF(A1<43152,A1*14%+400,IF(A1<53940,A1*15%+500,A1*15%+500)))
如何根据销售业绩算提成要excel表格形式?3万以下不提成含;满3万的...答:假设数据在A1 在B1中输入或复制粘贴此公式 提成比例 =IF(A1="","",LOOKUP(A1,{0,30000,40000,60001},{0,1,2,5}%))提成数量 =IF(A1="","",LOOKUP(A1,{0,30000,40000,60001},{0,1,2,5}%)*A1)下拉填充
帮忙 设计一个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<=...