I need to calculate a check digit for 20,000 large numbers in excel
I can manually do it as follows:
The Number is 33 digits long, each digit is multiplied alternating 1,2,1,2 the right most figure in the products are added together, the right most figure in the sum is subtracted from ten creating the check digit. ten is not a check digit it would be 0. Any help would be appreciated!
<TBODY>
</TBODY>
I can manually do it as follows:
The Number is 33 digits long, each digit is multiplied alternating 1,2,1,2 the right most figure in the products are added together, the right most figure in the sum is subtracted from ten creating the check digit. ten is not a check digit it would be 0. Any help would be appreciated!
1</SPAN> | 1</SPAN> | 5</SPAN> | 0</SPAN> | 1</SPAN> | 2</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 5</SPAN> | 0</SPAN> | 1</SPAN> | 0</SPAN> | 2</SPAN> | 4</SPAN> | 6</SPAN> | 3</SPAN> | 2</SPAN> | 0</SPAN> | 1</SPAN> | 3</SPAN> | 1</SPAN> | 2</SPAN> | 6</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 2</SPAN> | 5</SPAN> | 0</SPAN> | 0</SPAN> |
1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> | 2</SPAN> | 1</SPAN> |
1</SPAN> | 2</SPAN> | 5</SPAN> | 0</SPAN> | 1</SPAN> | 4</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 10</SPAN> | 0</SPAN> | 2</SPAN> | 0</SPAN> | 4</SPAN> | 4</SPAN> | 12</SPAN> | 3</SPAN> | 4</SPAN> | 0</SPAN> | 2</SPAN> | 3</SPAN> | 2</SPAN> | 2</SPAN> | 12</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 0</SPAN> | 4</SPAN> | 5</SPAN> | 0</SPAN> | 0</SPAN> |
1</SPAN> | 2</SPAN> | 5</SPAN> | 1</SPAN> | 4</SPAN> | 0</SPAN> | 2</SPAN> | 4</SPAN> | 4</SPAN> | 2</SPAN> | 3</SPAN> | 4</SPAN> | 2</SPAN> | 3</SPAN> | 2</SPAN> | 2</SPAN> | 2</SPAN> | 4</SPAN> | 5</SPAN> | ||||||||||||||
52</SPAN> | 2</SPAN> | |||||||||||||||||||||||||||||||
10</SPAN> | ||||||||||||||||||||||||||||||||
8</SPAN> | Check Digit</SPAN> |
<TBODY>
</TBODY>