Formula to find the PAN Criteria (1st 5 digits, 4-8 Digits, Last Digit of PAN) Example If PAN No. is "Oracle PAN no.
1st 5 digits (TEXT)"
AWIPK8054K AWIPK =LEFT(E21,5)
Example "Oracle PAN no.
4th-8th digit
(Numbers)"
AWIPK8664K 8664 =MID(E23,6,4)
Example "Oracle PAN no.
Last digit
(TEXT)"
AWIPK8399K K =RIGHT(E25,1)
Example "Oracle PAN Company
Type"
AWIPK8300K P =MID(E27,4,1)
AWICK8399K C
Formula to find if a PAN relates to Company / Non Company (As per 4th Letter of PAN) Example With above reference Formula^ "Oracle PAN Company
Type
as per Alpha"
P Non-Co =IF(F27="","",IF(F27="C","Co","Non-Co"))
C Co
Bookmarks