2022-23 NEW TAX REGIME EXCELL FORMULA

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%

Replies (1)

"Sorry, I am not a featured member."

For featured members contact.... https://www.caclubindia.com/catalogue/featured.asp

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 August 2026
Article Assistant

K R Kiran Kumar & Associates

Bengaluru

CA Inter

View Details
Company
19 August 2026
Chartered Accountant - Financial Consolidation & Reporting

Synergy Keystone

Mumbai

CA

View Details
Company
14 August 2026
Semi Qualified

Goyanka & Associates

New Delhi

CA Inter

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 24 August 2026
Chartered Accountant Articles

Rohit KC Jain & Co

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 14 August 2026
Article Assistant

N J Suresh & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
27 August 2026
ACCOUNTANT

CHARUPREETI & CO

Noida

Graduate (Any)

View Details