HOW TO 4TH DIGITS SEPARATE FROM 10 DIGITS WORD

[GVN KUMAR]

Sir

We are ETDs filing purpose 965 members data.

We are deducted TDS P , H status → 1% TDS deducted in pan card (4th letter)

We are deducted TDS C, F, A, B, H, status → 2% TDS deducted in pan card (4th latter)

So data having 945 pan no having but we are short deductions identification purpose and
penalty avoid purpose which foumula required.

Pan No " AFGPN 2938 F" system

 

[Ramesh]

First write the following formula in cell B2 and copy the same across all the rows..

=MID(A2,4,1)

Then in column C starting from cell C2 write the following formula and copy the same across all the rows..

=IF(B2="P",0.01,IF(OR(B2="C",B2="F",B2="A",B2="B",B2="H"),0.02,""))

I am here by attaching the updated file for your reference...

 

[GVN KUMAR]

Thank you sir,
thank you sir,

super success full formula ok