Using Excel for Tax Calcs Jun 2019

Share it with your friends Like

Thanks! Share it with your friends!

Close

How to use VLookup (all explained within) to get Excel to calculate tax rates.
https://www.canada.ca/en/revenue-agency/services/tax/individuals/frequently-asked-questions-individuals/canadian-income-tax-rates-individuals-current-previous-years.html
https://www.taxtips.ca/taxrates/bc.htm
=VLOOKUP(B2,FedTax,2,TRUE)+VLOOKUP(B2,FedTax,3,TRUE)*(B2-VLOOKUP(B2,FedTax,1,TRUE))

Comments

Write a comment

*

*