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业绩提成公式答:你这个类似个税,我想一下。10000以下的是20%吗?如果业绩在F3,公式:=ROUND(MAX(F3*{0.2,0.25,0.3,0.35,0.4,0.45,0.5}-{0,500,1500,2750,4250,6000,8500},0),2)