Excel如何计算销售提成的思路方法和公式答:销售提成计算方法一:D9单元格输入公式:=SUM((B9%%>{4,6,8,10})*(B9%%-{4,6,8,10})*0.01)*10^4+B9*6%,下拉完成。销售提成计算方法二:D9单元格输入公式:=LOOKUP(B9%%,{0,4,6,8,10},{6,7,8,9,10}%*B9-{0,2,5,9,14}/0.5%),下拉完成。下面两种销售提成计算方法是...
EXCEL怎么计算提成比例答:先给你个例子 如图,输入 =IF(A1-12000<5000,0.05,IF(A1-12000<=10000,0.1,IF(A1-12000<=15000,0.15,0.2)))*(A1-12000)如果你有兴趣,给你做个辅助列的!图中加了个辅助列,以后你要修改提成也好办。公式如下:=IF(A1<12000,0,VLOOKUP(A1-12000,$D$3:$E$6,2))*(A1-12000)直...