Hi all, forgive me for my ignorance but Modulus numbering is not my strength.
If we have the following algorithm =11-MOD(SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),
MOD(ROW(INDIRECT("1:"&LEN(A1)))-1,6)+2),11)
The weighting is linear 2 through to 8 I am lead to believe.
What if the weighting is not linear but actually set as the table below-:
Digit Weight
0 6
1 3
1 7
1 9
5 10
6 5
9 8
4 4
3 2
3 1
assuming the digit in cell A1 is 0111569433 and the weight is 6, 3, 7, 9, 10, 5, 8, 4, 2, 1
How do we enter this into the algorithm as follows-: =11-MOD(SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),
MOD(ROW(INDIRECT("1:"&LEN(A1)))-1,6)+2),11) as this a non linear example
Thank you in advance
Bookmarks