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
CAclubindia
Pro
Modal body text goes here.
CAclubindia
