软件:office excel
版本:2010
Income Tax Table
Threshold Fixed Tax Percentage
$0 and $18,200 0 0
$18,201 and $37,000 0 19%
$37,001 and $80,000 $3,572 32.50%
$80,001 and $180,000 $17,547 37%
$180,001 and over $54,547 45%
Annual Salary Income Tax
42,317.00 5,300
52,796.02 ?
77,290.63 ?
69,333.01 ?
53,943.30 ?
102,291.55 ?
请问有什么公式可以把不同的薪水 依照上面的课税级距算出要缴多少税吗
像第一个薪水42,317的税计算方法是Fixed Tax 3,572+(42,317-37000)*0.325=5,300
请高手帮帮忙 谢谢!