Excel 求助:用IF函数做扣税的公式

2025-03-10 23:47:39
推荐回答(3个)
回答1:

设B3是总收入,个税公式是
=ROUND(MAX((B3-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2)
用IF写的公式超7层了。

回答2:

=ROUND(MAX((B3-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0),2)
这是税务局给的代码

回答3:

你扣税的比例是怎么样的?请例出来,即扣税标准