2022-23 NEW TAX REGIME EXCELL FORMULA

hiteshkumar.prajapati@yahoo.co (no) (25 Points)

29 May 2023  

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%