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
Menu
Excel formula
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
Recent Topics :
- Consultation
- E-way notices2222
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
Related Topics :
CAclubindia
