Does anyone have an Excel formula for calculating total tax (for 2018 federal income) for a given taxable income?
Yes, I’ve googled around for this, but found one that assumes you have the discrete tax tables in another spreadsheet, and also many .xlsx files that appear that they could contain malware.
I mean … I know the brackets (below) but putting this into an Excel formula is alluding me.
|Federal tax brackets - Married Filing Jointly||This amount||plus|
|0-19050||0||10% over 0|
|19050-77400||1905||12% over 19050|
|77400-165000||8907||22% over 77400|
|165000-315000||28179||24% over 165000|
|315000-400000||64179||32% over 315000|
|400000-600000||91379||35% over 400000|
|600000 and above||161379||37% over 600000|