OLD REGIME FORMULA
=ROUND(IF(I7836<500000,K7838*0.05,IF(I7836<1000000,IF(K7837=250000,12500+(I7836-500000)*0.2,12500+(I7836-500000)*0.2),IF(K7837=250000, 112500+(I7836-1000000)*0.3, 112500+(I7836-1000000)*0.3))),0)
ANY ONE PLEASE HELP NEW TAX REGIME FORMULA
Net taxable income New Tax Regime
Up to 2.5lakhs Exempt
2.5 – 5 lakhs 5%
5-7.5 lakhs 10%
7.5-10 lakhs 15%
10-12.5 lakhs 20%
12.5-15 lakhs 25%
15 lakhs and above 30%
CAclubindia
