| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a Check Digit Routine
I have the following formula that is used to calculate a MOD 10 check digit
routine. For example: If I entered (8 digits) 45678912 in cell A1, the formula would return a 2 as the 9th digit. This is the formula that I am using but did not write so I'm having trouble following it. =10-MOD(SUM(--MID(TEXT($A1,"000000000"),{2,4,6,8},1),--RIGHT(MID(TEXT($A1,"000000000"),{1,3,5,7,9},1)*2),--LEFT(TEXT((MID(TEXT($A1,"000000000"),{1,3,5,7,9},1 )*2),"00"))),10) I need to modify this formula so that it will look at 15 digits and calculate the 16th. I've tried multiple things but have had no luck. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GTIN-12 Check digit calculator | Excel Discussion (Misc queries) | |||
| Removing a check digit | Excel Discussion (Misc queries) | |||
| Creating a Check Digit | Charts and Charting in Excel | |||
| Mod-10 Check Digit | Excel Worksheet Functions | |||
| Mod-10 Check Digit | Excel Worksheet Functions | |||
Threaded Mode
