banner_ad

Excel formula

Excel for Finance 1010 views 9 replies

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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
14 May 2026
Senior Associate

ABHISHEK SHANKAR AGARWAL & ASSOCIATES

Kolkata

CA

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
07 June 2026
Tax Associate

Rajkumar Jain & Co.

Ahmedabad

Graduate (Any)

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 14 May 2026
CA ARTICLE

PRAVEEN GARG & CO

Faridabad

CA Foundation

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
18 May 2026
MIS Executive

Primarc Pecan Retail Limited

Mumbai

B.Com

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details