I need help

This query is : Resolved

C.A Alok Mukherjee (Querist)
Follow

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?

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

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

C.A Alok Mukherjee

C.A Alok Mukherjee (Querist)
Follow

15 October 2009 thank you for your help.

Upgrade to CAclubindia Pro. Subscribe Now!

C.A Alok Mukherjee

C.A Alok Mukherjee (Querist)
Follow

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?

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

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