Vezerid Modulus 11
thank you, I shall give it a go
"vezerid" wrote:
Michelle,
I just realized there was a detail in the algorithm I overlooked. The
following formula is, I believe, correct (at least it produces 2 for
the specific number; if you have other numbers that you can check
manually, or you already know the answer, you can check these as well).
=11-MOD(SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN( A1))),1)),MOD(LEN(A1)+1-ROW(INDIRECT("1:"&LEN(A1)))-1,6)+2),11)
Again it has to be array entered.
HTH
Kostis Vezerides
|