SOURCE: Variable tax rates in Excel
hi there
Here you go!
NOTE:
1) Cell A8 mentioned here can be changed according to the cell where you want the input.
2) Change the Cell Formatting of the input and output cell to Currency so that you can see the $ symbol.
=IF((A8<=6000),0,IF(AND(A8>=6001,A8<=216000),(((A8-6001)*17)/100),IF(AND(A8>=216001,A8<=58000),((((A8-216001)*30)/100)+2652),IF(AND(A8>=58001,A8<=70000),((((A8-58001)*42)/100)+13572),IF(A8>=70001,((((A8-70001)*47)/100)+18612))))))
Please let me know if you have any more queries
All the Best.
Was this solution helpful? Show your Appreciation by rating it:
SOURCE: how to calculate taxable Income and how to
Hi, I researched this "website" for you,(http://multiutils.com/itax/itax0910.htm) hopefully it will have the answer your looking for, thanks. "Rating the help is appreciated, just click on the "Thumbs."
SOURCE: Who provides different income tax slabs for both men & women?
As It is below the tax exemption limit, she does not need to pay income tax
http://www.itrtoday.com/resources/utilities/rate_of_income_tax
SOURCE: Canadian resident filing US tax return, how do I report income as an independent contractor?
Sounds like you would file a 1040NR and report the income you earned and your business expenses as an independent contractor on a Schedule C and the net income or loss from the Schedule C will go on line 13 of the form 1040NR if you are a individual an not a partnership or a corporation.
97 views
Usually answered in minutes!
×