Can someone please help me to write a formula to determine the PAN status of assesses using if Formula. suppose the PAN no is AACCA3426B and the fourth letter in this case is C so i want company to be displayed in next column and if the fourth letter is other than C then it should display result as non company.
Tried with that above formula. But Not working
SMJ global advisors pvt ltd
New Delhi
B.Com
View Details
R P S K & Associates
Nashik
CA Inter
View Details
CAclubindia
