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 Threads
- LTCG Tax on property
- Short term gain in itr2, missing 111A
- Errors in ITR Filing: Minimum One Character Requir
- Which ITR Opt
- Employer Details for NRI
- Section 194C or 194J apply in survey fee to determ
- Accidental Switch to New Regime using Form 10-IEA
- Should I file Revised Return U/S 139 (5)?
- Voice commands for Tally ERP - would CAs find this
- ITR-2 Filing Blocked – BFLA Schedule Bug in
Related Threads
CAclubindia
