calculating

[ROKYD]

Please, who can provide me a full formula enabling me to calculate the check digit(MOD 10) of the a given number?

PLEASE HELP ME . I NEED THE INFORMATION AS SOON AS POSSIBLE.
IAM RUSHING AND I DO NOT KNOW HOW TO OPERATE?

 

[VoG]

Look here http://xlsgen.arstdesign.com/core/formulas.html and scroll down to the table.

 

[ROKYD]

ok I WILL CHECK, could you please give me you email or messenger sothat I directly talk with you as soon as I go through?

kindest

 

[VoG]

You can send me a PM by clicking on my codename but it shouldn't be necessary.

 

[laloma]

Check Digit 10

Dear Mr. Coderre:

We just trying to use the following formula given by you on this site to calculate a check digit for a 10 digit number:

>>>>> =10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9},1))+SUMPRODUCT(--MID(A1,{2,4,6,8,10},1)*3),10)) <<<<<<

We founded that some times the check digit retirned is 10 while calculated from: 1000000003 or 1000000016 or 1000000029, and so on.

How we correct this ?

Regards,

 

[Ron Coderre]

Re: Check Digit 10

Assuming the check-digit you want in those circumstances is zero...
try this:
=MOD(10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9},1))+SUMPRODUCT(--MID(A1,{2,4,6,8,10},1)*3),10),10)

Also, for reasons I still don't understand, this formula seems to return the correct check-digit:
=A1 - FLOOR(A1 - 1, 9)

Does that help?

 

[laloma]

Mr. Coderre:

Don´t understand =A1 - FLOOR(A1 - 1, 9)

Regards,

 

[laloma]

Mr. Coderre:

This formula also returns a 10 check digit.

Regards,