算个人所得税3500-5000这段用IF公式怎么不对
IF(H2>8000,(H2-3500)*0.2-555,IF(8000>=H2>5000,(H2-3500)*0.1-150,IF(5000>=H2>3500,(H2-3500)*0.03,0)))哪位高人指点一下
应该是:8000>=H2>5000,(H2-3500)*0.1-105!不是减去150!
热门标签:
IF(H2>8000,(H2-3500)*0.2-555,IF(8000>=H2>5000,(H2-3500)*0.1-150,IF(5000>=H2>3500,(H2-3500)*0.03,0)))哪位高人指点一下
应该是:8000>=H2>5000,(H2-3500)*0.1-105!不是减去150!