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分段计算公式,谢谢大侠!答:公式为:=SUMPRODUCT(TEXT(A1-{0,60,80,100,150},"0.00;!0")*{0,5,1,1,1})如图所示: