Pablo wrote...
Mod 10 & Mod 11 are alogrithms for assigning a check-digit value to an ISBN
in the publishing world.
Mod 11 - calculates a sum based on the first nine digits, beginning at the
9th digit
example
0 3 9 3 0 4 0 0 2 (ISBN)
10 9 8 7 6 5 4 3 2 Weight
0 27 72 21 0 20 0 0 4 = 144
Check digit = mod11 (11 - mod11 (144)) = 10
Try
=11-MOD(SUMPRODUCT(--MID(SUBSTITUTE(ISBN_without_check_digit,"-",""),
{9;8;7;6;5;4;3;2;1},1),{2;3;4;5;6;7;8;9;10}),11)
Mod 10 - calculates the check digit, 13th off of
9 7 8 0 3 9 3 0 4 0 0 2 (ISBN)
1 3 1 3 1 3 1 3 1 3 1 3 Weight
9 21 8 0 3 27 3 0 4 0 0 6 = 81
Check digit = mod10 (10 - mod10 (81)) = 9
Try
=10-MOD(SUMPRODUCT(--MID(SUBSTITUTE(ISBN_without_check_digit,"-",""),
{12;11;10;9;8;7;6;5;4;3;2;1},1),{3;1;3;1;3;1;3;1;3 ;1;3;1}),10)
|