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
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details