怎么用excel根据毛利率计算提成答:提成比例:D2=IF(C2<=0,0.3%,LOOKUP(C2*100,{0,15,25,35},{1,1.5,2,8}*1%))提成金额:E2=B2*IF(C2<=0,0.3%,LOOKUP(C2*100,{0,15,25,35},{1,1.5,2,8}*1%))复制并下拉,即可。提问题时上的图,下次记得务必要有行列标号的!否则没有办法给你公式的!本例是以”商品名...
EXCEL分段式计算业绩提成公式答:例如:提成规则:3W及以下 3% 3W-4W 6% 4W-6W 8% 6W-8W 10% 8W及以上 12% 则公式为 =LOOKUP(A2,{0,3,4,6,8}*10^4+1,A2*{0.03,0.06,0.08,0.1,0.12}-{0,900,1700,2900,4500})
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%)))