Excel file to check whether pan no. is valid or not


@VaibhavJ (Believe!! Live your dreams!)     29 December 2012

@VaibhavJ
Believe!! Live your dreams! 
 4736 likes  33421 points

| My Other Post

Hi,

 

I have made a PAN checking function in excel.

 

This will check whether PAN no. supplied is correct ot not.

 

To check this in cell type formula =ispanvalid(A1)

where A1 is cell reference in which pan no. is typed.

 

https://docs.google.com/open?id=0B7i2wkMBVw9xQ2ZYekJKUUVqWFU

 

Also make sure that your MACRI is enabled.

 

Pl check & confirm about the functioning of the same & error if any.

Thanks!!

7 Like
avater

Saurabh Malpani (CA Final)     29 December 2012

Saurabh Malpani
CA Final 
 34 likes  514 points

View Profile | My Other Post

 

#NAME?

 

avater

@VaibhavJ (Believe!! Live your dreams!)     29 December 2012

@VaibhavJ
Believe!! Live your dreams! 
 4736 likes  33421 points

View Profile | My Other Post

Originally posted by : Saurabh Malpani

 




#NAME?




 

Please enable macro..thanks!!

1 Like
avater

Dhanya Sreedhar (CA final, doing Job)     29 December 2012

Dhanya Sreedhar
CA final doing Job 
 123 likes  661 points

View Profile | My Other Post

Its working....Nice one...Thanks for sharing smiley  yes

avater

geetha (student)     29 December 2012

geetha
student 
 38 likes  394 points

View Profile | My Other Post

thank u , it was easy .. yes

avater

manoj (student)     30 December 2012

manoj
student 
 404 likes  5115 points

View Profile | My Other Post

GOOD ONE VAIBHAV

1 Like
avater

Ramesha.M (Accountant)     31 December 2012

Ramesha.M
Accountant 
 36 likes  794 points

View Profile | My Other Post

Dear Brother 

 

Working your formula 

Good Work

Thank you so much for sharuing

 

Best Regards

Ramesha.M

1 Like
avater

manoj kumar (student)     31 December 2012

manoj kumar
student 
 1 likes  41 points

View Profile | My Other Post

Vaibhav ,How can we use it.

shall i have to do any setting in my excel.

I have Excel 2007

My mail id is kumarmanoj258 @ gmail.com

avater

@VaibhavJ (Believe!! Live your dreams!)     31 December 2012

@VaibhavJ
Believe!! Live your dreams! 
 4736 likes  33421 points

View Profile | My Other Post

Originally posted by : manoj kumar

Vaibhav ,How can we use it.

shall i have to do any setting in my excel.

I have Excel 2007

My mail id is kumarmanoj258 @ gmail.com

you can use formual only in this workbook..

You have to enable macro so as to function work..

pl let me know if youi wish to make it default for all!!

Thanks!!

avater

Chintan (C.A)     31 December 2012

Chintan
C.A 
 19 likes  128 points

View Profile | My Other Post

Originally posted by : Dhanya Sreedhar

Its working....Nice one...Thanks for sharing   


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  




Popular Discussion


view more »