Excel formula

I WANT TO APPLY “IF” FORMULA IN EXCEL FOR FOLLOWING 


THE FORMULA SERACH ON PAN IF ITS FOURTH ALPHABET IS “P OR H” IT RESULT IN “IND/HUF” IF THE FOURTH ALBHABET IS “C/F/J/T” IT RESULTS IN “OTHER THAN IND/HUF”


PLEASE HELP ME ITS LITTLE BIT URGENT

Replies (9)

=IF(LEFT(RIGHT(F3,7),1)="P","IND",(IF(LEFT(RIGHT(F3,7),1)="H","HUF","OTHER")))

please check , and let me know of any modification req

Thank You Mayur Ji

Can You explain me this formula, so that formula can be made more wide

so that I not need to distrub you again and again

can you give me your contact No.

Mayur Ji Formula Further Modified Thanks for the help

Thanks Lot Once Again

Mayur Ji Formula Further Modified Thanks for the help Thanks Lot Once Again it can help every one in TDS returns

Welcome Gopal ji. 

 

=IF(LEFT(RIGHT(F6,7),1)="P","IND",(IF(LEFT(RIGHT(F6,7),1)="H","HUF",(IF(LEFT(RIGHT(F6,7),1)="C","COMPANY",IF(LEFT(RIGHT(F6,7),1)="T","TRUST",(IF(LEFT(RIGHT(F6,7),1)="F","FIRM","OTHER"))))))))

One moe simple formula to find 4th character

=MID(A1,4,1)

Thank you

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details