# Income Tax Calculation

1. ## Income Tax Calculation

Hi!

I need a formula to calculate Income Tax. The Calculation is mentioned below -

Consider the Salary to be 460,000.

Following are the Tax Slabs -

0 - 150,000 - 0% Tax
150,000 - 300,000 - 10% Tax
300,000 - 500,000 - 20% Tax
500,000 - 700,000 - 30% Tax
More than 700,000 - 35% Tax

So Basically out of our Salary of Rs. 460,000 the 1st 150,000 will be Non Taxable, 150,000 will be Taxed @ 10% & the remaining 160,000 @ 20%.

Can anyone help me out with this? (Sample File Attached)

Cheers!

Deep

2. ## Re: Income Tax Calculation

See this...

http://mcgimpsey.com/excel/variablerate.html

3. ## Re: Income Tax Calculation

Hi,

One way amongst several

Formula:
`Please Login or Register  to view this content.`

4. ## Re: Income Tax Calculation

Hi!

Thank You for the solutions.. Great Help! I had solved the same using Choose & Match

I just changed the Slabs from Upper Limits to Lower Limits & used the below Formula -

``Please Login or Register  to view this content.``
Deep

5. ## Re: Income Tax Calculation

Originally Posted by Tony Valko
Thank you; very clearly and thoroughly explained.

6. ## Re: Income Tax Calculation

You're welcome. Thanks for the feedback!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1