怎么用excel函数计算提成比例答:在E2单元格输入以下公式,然后向下填充公式,并设置E列单元格格式为百分比。=LOOKUP(D2,{0,150,400,600,800},{0,7,9,12,15}*0.1%)
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函数公式怎么算啊答:=MIN(C2,4200)*0.12+(MIN(C2,8000)-4200)*0.13*(C2>4200)+(MIN(C2,12000)-8000)*0.14*(C2>8000)+(MAX(12000,C2)-12000)*0.15*(C2>12000)也可以用下面公式 =LOOKUP(A1,{0,4200,8000,12000},{0.12,0.13,0.14,0.15})*(A1-LOOKUP(A1,{0,4200,8000,12000}))+LOOKUP(A1,...