MOD 10 calculting

[ROKYD]

Dear all,

I have that formula on excell to calculate the MOD 10 value for a DIGIT CHECK.

BELOW THE FORMULA.
[FONT=&quot]<o></o>[/FONT]
[FONT=&quot]=10-MOD(SUMPRODUCT(--MID(A1,{1,3,5,7,9,11,13,15,17},1))+<o></o>[/FONT]
[FONT=&quot]SUMPRODUCT(--MID(A1,{2,4,6,8,10,12,14,16,18},1)*3),10)[/FONT]

It works for a number but it is not working for the other.
Please; help me.

example datas : 5290000040000850120 /// THE RIGHT NUMBER IS : 2
it is ok for that number:

the other number :

5290000040000850044 // the right number : 4 after the 44

 

[ROKYD]

THANK YOU

THIS THE RESULT OF THE TEST

{0.0}

TELL ME

WHAT KIND OF OPERATION IS THE {1;2}?

division???????????

 

[barry houdini]

{0.0}

If you get that then it looks like you have . as the column separator so the formula would be

=MOD(SOMMEPROD(-STXT(TEXTE(STXT(A1;LIGNE(INDIRECT("1:"&NBCAR(A1)));1)*(MOD(LIGNE(INDIRECT("1:"&NBCAR(A1)))+NBCAR(A1)+1;2)+1);"00");{1.2};1));10)

The {1.2} part just helps to extract the digits from

{"09";"04";"05";"00";"00";"00";"00";"00";"04";"00";"00";"00";"05";"16";"00";"02";"02";"00"}

so that they can all be summed.......

 

[ROKYD]

YEAHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
YOU ARE RIGHT

IT IS OK NOW FOR ALL THE EXAMPLE DATAS :
1 : <table style="border-collapse: collapse;" width="180" border="0" cellpadding="0" cellspacing="0" height="20"><col style="width: 123pt;" width="164"><tr style="height: 15pt;" height="20"> <td class="xl63" style="height: 15pt; width: 123pt;" width="164" height="20">925000004000580047</td> </tr></table><table style="border-collapse: collapse; width: 123pt;" width="164" border="0" cellpadding="0" cellspacing="0"><col style="width: 123pt;" width="164"><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 123pt;" width="164" height="20">925000004000580044</td> </tr></table><table style="border-collapse: collapse; width: 123pt;" width="164" border="0" cellpadding="0" cellspacing="0"><col style="width: 123pt;" width="164"><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 123pt;" width="164" height="20">925000004000580120

</td> </tr></table>SO THE BEST FORMULA IN FRENCH IS :

=MOD(SOMMEPROD(-STXT(TEXTE(STXT(A1;LIGNE(INDIRECT("1:"&NBCAR(A1)));1)*(MOD(LIGNE(INDIRECT("1:"&NBCAR(A1)))+NBCAR(A1)+1;2)+1);"00");{1.2};1));10)

I DO NOT KNOW HOW TO THANK YOU FOR YOUR AVAILABILITY.

THANK YOU VERY MUCH.

GOD BLESS YOU.

YOU KNOW , I AM VERY HAPPY BECAUSE THANKS TO YOU, I WILL HAVE A GOOD NIGHT AND TOMOROW MORNING I WILL BE PROUD TO MAKE A PRESENTATION TO MY CUSTOMER.
COULD YOU PLEASE SEND ME A PRIVATE MESSAGE SOTHAT WE GET N TOUCH?

THKS FOR ALL