Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need help generating a check digit for a 17 digit number using the Modulus 10 - weight 2 method. Rules below. 21212121212121212
(Modulus 10 – Weight 2) The algorithm for calculating the check digit is as follows: 1. Working from right to left – multiply every other digit by two. Any carry, the “1” from any two digit product is added to the product of the next multiplication operation. If the product of the final multiplication operation is greater than nine, add the two digits of the product together and if there is a carry from the previous multiplication operation, add it to the sum of the two digits. (As illustrated in the example below for the first 9 in the ORGID: 9 x 2 = 18, 1+8 = 9, add the carry of 1 from the previous multiplication operation: 9 + 1 = 10.) 2. The digits in the products and the digits in the base number not multiplied by two are added together. 3. The total is subtracted from the next higher number ending in zero. If the total ends in zero, the number is subtracted from itself. 4. The difference is the check digit. Example: ORGID = 9594567 Sequence # = 0123456789 Check Digit= ? 0. Base Number 95945670123456789 - 8 Answer - 8 for check digit. How can I do this for other 17 digit numbers? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get excel to check last 2 digits in a 4 digit number | Excel Discussion (Misc queries) | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
How to write vba to check the last digit of hong kong ID card number | Excel Programming |