Question

excel怎么计算销售提成：

达不到69000时，不计提成
69000时，按5%提成
69000—90000（不含69000）提成8%
90000—120000（不含90000）提成12%
120000以上，提成15%
照上面的公式，得出的结果，比人工计算的多。是什么回事啊，请指教

Answer 1

=IF(A1="","",LOOKUP(A1,{0,30000,40000,50000,60000,80000,100000,130000}+10^-8,{5,6,7,8,9,10,12,13}%))

Answer 2

4200*0.12+（8000-4200）*0.13+（12000-8000）*0.14+（80000-12000）*0.15

Answer 3

结果应该是　　11758
=MAX(A1*{12,13,14,15}%-{0,42,122,242})

Answer 4

=if(a1<69000,0,if(a1<90000,a1*8/100,if(a1<120000,a1*12/100,a1*15/100)))

Answer 5

=a1*if(a1>120000,0.15,if(a1>90000,0.12,if(a1>69000,0.8,if(a1=69000,0.5,0))))