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

 

[Domenic]

For the French version, you might need to replace...

{1,2}

with

{1\2}

 

[ROKYD]

Hi,

Thank you for your attention,

What I write was just a translation of the code that I got here.

TEXT IS TESTE
MID IS STXT AND SO ON
this is the website where you can see it

http://xlsgen.arstdesign.com/core/formulas.html

COULD YOU PLEASE SEND ME YOUR EXCEL SHEET( EVEN IN ENGLISH) SO THAT I SEE HOW YOU PROCEED?

I LOOF FORWARD TO READING YOUR REPLY.

THANK YOU IN ADVANCE FOR YOUR ATTENTION.

 

[VoG]

Veuillez ne pas saisir les capitaux. Cela est considéré comme criant.

 

[barry houdini]

Hello ROKYD,

Can you try Domenic's suggestion, i.e.

=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)

That should fix it......

Domenic, I presume in {1,2} that the comma will be treated like a decimal point?

 

[Domenic]

Domenic, I presume in {1,2} that the comma will be treated like a decimal point?

I don't use the French version, but I believe so...

 

[ROKYD]

I STILL HAVE 9

THIS IS THE RESULT OF WHAT YOU ASK ME TO DO

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

BY COMPARING YOURS AND MINE, I notice that it is the same.

COULD YOU CHECK AND TELL ME WHAT TO DO?

THANK YOU

 

[barry houdini]

Yes, that's what you should get.....but the wrong result was caused by the next part, i.e.

{1,2}

did you change that to {1\2}

?

 

[ROKYD]

Hello ROKYD,

I have tried Domenic's suggestion, i.e.

=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)

Unfortunately, it is said that there is a mistake in the formula because of the "\"

kindest

 

[barry houdini]

OK can you do a little test? Find 2 horizontally adjacent cells that are empty, e.g. A5 and B5.

Now in another cell just type this formula

=A5:B5

The cell will probably show an error but you can ignore that.....

select the cell with the formula, press F2 and press F9...can you copy that and paste the result here?

 

[ROKYD]

yes I have done it, I think that I will to set up office in english and see , if I could have the best result?

Did you get 4 for the 925000004000580044
and 7 for the 925000004000580047?

Do you think that by installing excel in english, I SHOULD have a good result?