设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层了。
=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)这是税务局给的代码
你扣税的比例是怎么样的?请例出来,即扣税标准