LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 4
Default check digit number

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
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
How to get excel to check last 2 digits in a 4 digit number realtorpete Excel Discussion (Misc queries) 3 January 4th 09 08:52 PM
How to validate a cell to insert from 9 digit number to 13 digit number. ramulu via OfficeKB.com Excel Worksheet Functions 1 February 21st 07 02:32 PM
How to validate a cell to insert from 9 digit number to 13 digit number. ramulu Excel Worksheet Functions 1 February 21st 07 10:00 AM
When we enter a 16 digit number (credit card) the last digit chan. ceking Excel Discussion (Misc queries) 5 December 8th 04 11:45 PM
How to write vba to check the last digit of hong kong ID card number eric chan Excel Programming 3 October 15th 03 04:15 AM


All times are GMT +1. The time now is 03:19 PM.

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

About Us

"It's about Microsoft Excel"