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
Length multiplied by width equals sq feet. Measure each separately.
24 views
Usually answered in minutes!
×