• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tax Calculation

Status
Not open for further replies.
I have an excel file where I have to calculate the tax amount according to the old and new tax slab. In the Type column when I select the old or new it get automatically change as per old or new tax slab. I have written the answer of the tax amount for your help as per the old tax slab. Now how to change the amount as per old and new regime. The tax slab is like this.

Old TaxSlabNew TaxSlab
0-250000000-25000000
>250000 - <=50000010%>250000 - <=5000005%
>500000 - <=100000020%>500000 - <=75000010%
>100000030%>750000 - <=100000015%
>1000000 - <=125000020%
>1250000 - <=150000025%
>150000030%
 

Attachments

  • Tax.xlsx
    10.8 KB · Views: 1
Status
Not open for further replies.
Back
Top