I need help
This query is : Resolved
14 October 2009
I want to denote the PAN database. Now suppose a PAN is ADOPM5655S, i want to denote it on the basis of the 4th caracter i.e "P" as individual Similarly suppose in case of a Company, it would be as "C" the fourth caracter. How can i do this by using the formula?
14 October 2009
ADOPM5655S write in A1 columns
type commnd in B1 columns
=LEFT(RIGHT($A$1,7),1)
result = "P"
=IF(b1="P","IND",IF(b1="C","comp",IF(b1="a","AO",IF(b1="h","HUF",))))
type commnd in B1 columns
=LEFT(RIGHT($A$1,7),1)
result = "P"
=IF(b1="P","IND",IF(b1="C","comp",IF(b1="a","AO",IF(b1="h","HUF",))))
15 October 2009
thank you for your help.
15 October 2009
Ram, i am not getting the result. Can you please check? the moment i write the $then moving the cursor to A1, it's throwing an error message. Can you please check once again?
15 October 2009
Plaease download by this link we have attached excel sheet for you.
https://www.caclubindia.com/forum/message_display.asp?group_id=51924&message=MESSAGE%20MODIFIED
https://www.caclubindia.com/forum/message_display.asp?group_id=51924&message=MESSAGE%20MODIFIED
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Tds on building rent monthly
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Confusion around Form 26QB fields
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Tax on income from business can set off house property loan
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- BUYING PROPERTY COULD NOT FILE 26QB
- Gst input for FY 23-24
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
Trending Online Classes
CAclubindia
