Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 4
Default Generate Check Digit

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

Answer - 8 for check digit. How can I do this for other 17 digit numbers?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to generate 3 digit numbers out of 0 to 9 number Biyani Excel Discussion (Misc queries) 3 September 13th 09 01:20 PM
Generate alphanumeric unique 4 digit values from 12 digit values mikep Excel Worksheet Functions 5 February 9th 07 09:59 PM
How do I generate a list of 5-digit numbers in Excel? Cowboy Excel Programming 5 June 29th 05 03:57 PM
Mod-10 Check Digit Union70 Excel Worksheet Functions 1 March 25th 05 12:35 AM
Mod-10 Check Digit Union70 Excel Worksheet Functions 4 March 8th 05 08:58 AM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"