GOPAL AGGARWAL (DOING NOTHING) (1339 Points)
22 December 2017I 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
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")))
CA Mayur Todmal
(Practicing CA)
(7756 Points)
Replied 22 December 2017
please check , and let me know of any modification req
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
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"))))))))
CA Mayur Todmal
(Practicing CA)
(7756 Points)
Replied 25 January 2018
One moe simple formula to find 4th character
=MID(A1,4,1)
CAclubindia
