=IF(A2-5000>85000,(A2-5000)*0.45-15160,IF(A2-5000>60000,(A2-5000)*0.35-7160,IF(A2-5000>40000,(A2-5000)*0.3-4410,IF(A2-5000>30000,(A2-5000)*0.25-2660,IF(A2-5000>17000,(A2-5000)*0.2-1410,IF(A2-5000>8000,(A2-5000)*0.1-210,IF(A2-5000>0,(A2-5000)*0.03,0)))))))
=(A14-5000)*VLOOKUP(A14,$D$1:$F$9,2,1)-VLOOKUP(A14,$D$1:$F$9,3,1)
为什么这两个函数的计算结果存在差异？我验算之后IF函数是正确的。VLOOKUP错在哪了？
求大佬解答
