Excel query regarding PAN no

Cost Accounts 592 views 4 replies
User Avatar

Accounts Assitant
23 Points Joined June 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.

 

0 Reply Share Follow
On 12 September 2022 at 17:55 Report
Replies (4)
User Avatar

27876 Points Joined May 2017
Not a pertinent question indeed.
Reply
On 12 September 2022 at 22:04
User Avatar

Practising CA
8944 Points Joined December 2013
=IF((LEFT(RIGHT(A1,4),1)="C","Company","Non-Company")
Reply
On 13 September 2022 at 02:10
User Avatar

Accounts Assitant
23 Points Joined June 2022

Tried with that above formula. But Not working

Reply
On 13 September 2022 at 22:24
User Avatar

CFO- at NHTF
58275 Points Joined August 2012
PAN formula is confidential. And it is for dept internal purposes only ..

Only 4th letter and last letter open
Reply
On 17 September 2022 at 14:50


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading