急急急求大神帮我制作一个EXCEL表格,来计算提成的。答:A1为业绩 B1公式为提成。=IF(A1>40000,(A1-40000)*0.15+3900,IF(A1>30000,(A1-30000)*0.13+2600,IF(A1>20000,(A1-20000)*0.12+1400,IF(A1>15000,(A1-15000)*0.1+900,IF(A1>10000,(A1-10000)*0.08+500,A1*0.05)))简化一下:=LOOKUP(A1,{0,10000,15001,20001,30001,40001...