Excel query regarding PAN no

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.

 

Replies (4)
Quick Summary
This discussion seeks an Excel formula to determine if a PAN number indicates a 'Company' or 'Non-Company'. The user wants to check the fourth letter of the PAN; if it's 'C', it should be classified as 'Company', otherwise 'Non-Company'. While a formula was suggested, it wasn't working as expected, and the user noted the PAN format is confidential for internal departmental use only, with specific constraints on which letters can be revealed.

Not a pertinent question indeed.
=IF((LEFT(RIGHT(A1,4),1)="C","Company","Non-Company")

Tried with that above formula. But Not working

PAN formula is confidential. And it is for dept internal purposes only ..

Only 4th letter and last letter open

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details