Formula for Credit Card digits Checking

[mianmazher]

Is there any way to check that the credit Card number entered in the cell is either VAlid or not ( I am asking abt the valididity of the Checksum not the validity of teh cRedit Card Number)(

I tyhink its teh Luhans Formula which uses MOD 10

Further more some cards have 16 Digits some have 14 Digits

Help Needed


Regards


Mian Mazher

 

[Andrew Poulsom]

A search on Google for "credit card check Excel" came up with this:

http://www.beachnet.com/~hstiles/cardtype.html

and several more.

 

[mianmazher]

Thanx Sir Andrew

I will try to make


Reagards

Mian Mazher

 

[rrdonutz]

A couple of threads that address Luhn's formula (more or less) and might help:

http://www.mrexcel.com/board2/viewtopic.php?t=60874
[How To Calculate Check Digit (MOD 10)]

and more recently--

http://www.mrexcel.com/board2/viewtopic.php?t=78822
[checking formula.. need help]

 

[mianmazher]

Thanx

rrdonutz


Regards


mian Mazher