Excel query regarding PAN no

NIKHIL GULE (Accounts Assitant) (23 Points)

12 September 2022  

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.