EXCEL中超过7层以上IF语句的替代方案

贴一个做好的计算扣个人所得税的公式:

=A1*LOOKUP(A1,{0,2001,2501,4001,7001,22001,42001,62001,82001,102001},{0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45})-LOOKUP(A1,{0,2001,2501,4001,7001,22001,42001,62001,82001,102001},{0,0,25,125,375,1375,3375,6375,10375,15375})

One Response

Subscribe to comments with RSS.

  • zz says:

    看来LZ跟我一个深受Excel之困..
    Anyway, nothing is impossible in it.