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
Gupta Sachdeva & Co. Chartered Accountants
New Delhi
CA Final
View Details
CAclubindia
