• 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.

Completion of Incom Tax Calculation dformula

chsprasad

New Member
=IF(G63<400000,0,IF(AND(G63>400000,G63<800000),(G63-400000)*5%,IF(AND(G63>800000,G63<1200000),20000+(G63-800000)*10%,IF(G63>1200000,40000+(G63-1200000)*15%))))

Kindly let me know how to complete this formula for IT FY 2025-26 in New Tax Regime
Income Tax Slabs (Rs.)Income Tax Rate (%)
From 0 to 4,00,000
From 4,00,001 to 8,00,0005
From 8,00,001 to 12,00,00010
From 12,00,001 to 16,00,00015
From 16,00,001 to 20,00,00020
From 20,00,001 to 24,00,00025
From 24,00,001 and above30
 
an alternative is with vlookup

Income Tax Slabs (Rs.)Income Tax Rate (%)Income
2100000​
0​
0​
25​
400001​
5​
800001​
10​
1200001​
15​
1600001​
20​
2000001​
25​
2400000​
30​

=VLOOKUP(E1,A2:B8,2,TRUE)
 
Back
Top