[已解决]赠BB求公式组合

月光不合

u9GKdcJU.rar (3.63 KB, 下载次数: 0)

2010-4-26 22:57 上传

点击文件名下载附件
赠BB求公式组合

最佳答案

月排行榜 / 总排行榜

tiger下山

2010-4-27 09:30

如果一定要按你的公式，那就把公式改为：=IF(A2-2000<=0,0,IF(A2-2500<=0,(A2-2000)*0.05,IF(A2-4000<=0,25+(A2-2500)*0.1,IF(A2-7000<=0,175+(A2-4000)*0.15,IF(A2-22000<=0,625+(A2-7000)*0.2,IF(A2-42000<=0,3625+(A2-22000)*0.25,IF(A2-62000<=0,8625+(A2-42000)*0.3,IF(A2-82000<=0,14625+(A2-62000)*0.35,))))))))+IF(AND(A2-82000>0,A2-102000<=0),21625+(A2-82000)*0.4,IF(A2-102000>0,29625+(A2-102000)*0.45))

跳转到最佳答案楼层

pc520

=SUM(TEXT(A2-{2;2.5;4;7;22;42;62;82;102}*1000,"0;!0")*5%)

wayy

=SUM(TEXT(A2-{2;2.5;4;7;22;42;62;82;102}*1000,"0;!0")*5%)

与楼上一致，为个税最简公式了。

月光不合

我想要寻求附件内的公式如何能溶合到一起,学一种方法,并不是缺个人所得税公式!

tiger下山

如果一定要按你的公式，那就把公式改为：=IF(A2-2000<=0,0,IF(A2-2500<=0,(A2-2000)*0.05,IF(A2-4000<=0,25+(A2-2500)*0.1,IF(A2-7000<=0,175+(A2-4000)*0.15,IF(A2-22000<=0,625+(A2-7000)*0.2,IF(A2-42000<=0,3625+(A2-22000)*0.25,IF(A2-62000<=0,8625+(A2-42000)*0.3,IF(A2-82000<=0,14625+(A2-62000)*0.35,))))))))+IF(AND(A2-82000>0,A2-102000<=0),21625+(A2-82000)*0.4,IF(A2-102000>0,29625+(A2-102000)*0.45))

zxy999

=IF(A2-2000<0,0,IF(A2-2500<0,(A2-2000)*0.05,IF(A2-4000<0,25+(A2-2500)*0.1,IF(A2-7000<0,175+(A2-4000)*0.15,IF(A2-22000<0,625+(A2-7000)*0.2,IF(A2-42000<0,3625+(A2-22000)*0.25,IF(A2-62000<0,8625+(A2-42000)*0.3,IF(A2-82000<0,14625+(A2-62000)*0.35,21625+(A2>=102000)*8000+(A2-82000-(A2>=102000)*20000)*(0.4+0.05*(A2>=102000))))))))))

楼主是要这样的效果吗?

月光不合

QUOTE:

以下是引用zxy999在2010-4-27 9:32:00的发言：

=IF(A2-2000<0,0,IF(A2-2500<0,(A2-2000)*0.05,IF(A2-4000<0,25+(A2-2500)*0.1,IF(A2-7000<0,175+(A2-4000)*0.15,IF(A2-22000<0,625+(A2-7000)*0.2,IF(A2-42000<0,3625+(A2-22000)*0.25,IF(A2-62000<0,8625+(A2-42000)*0.3,IF(A2-82000<0,14625+(A2-62000)*0.35,21625+(A2>=102000)*8000+(A2-82000-(A2>=102000)*20000)*(0.4+0.05*(A2>=102000))))))))))

楼主是要这样的效果吗?

因为4楼更接近我的题意,你的也不错,谢谢!