Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Excel formula

GOPAL AGGARWAL (DOING NOTHING) (1339 Points)

22 December 2017

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

Reply
Follow
Share

9 Replies

CA Mayur Todmal (Practicing CA) (7756 Points)
Replied 22 December 2017

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

2 Like

Upgrade to CAclubindia Pro. Subscribe Now!

CA Mayur Todmal (Practicing CA) (7756 Points)
Replied 22 December 2017

please check , and let me know of any modification req

1 Like

GOPAL AGGARWAL (DOING NOTHING) (1339 Points)
Replied 23 December 2017

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.

GOPAL AGGARWAL (DOING NOTHING) (1339 Points)
Replied 23 December 2017

Mayur Ji Formula Further Modified Thanks for the help

Thanks Lot Once Again

GOPAL AGGARWAL (DOING NOTHING) (1339 Points)
Replied 23 December 2017

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

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

CA Mayur Todmal (Practicing CA) (7756 Points)
Replied 25 December 2017

Welcome Gopal ji.

CA Mayur Todmal (Practicing CA) (7756 Points)
Replied 25 December 2017

=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"))))))))