Hello all i have been reading this is the first i am writing .
i have read on how to get a upc check digit from a calculation most have more then one cell to work from.
what i have is a product list for about 3000 items each with a barcode number but if the item is not currently in production
it will only have 11 digits so when in production we manually add the 12 check digit to the sheet.
i have conditional formatting on the column (in this case its D )
=SUM((LEN($D1))=11) which changes the background of the cell to grey
=SUM((LEN($D1))=11) which changes the background of the cell to green
so my question ?
i would like to add another rule that will add the check digit to the number that meets the following condition if column A is not unique
Column A is our model number which if not in use is N/A and if in use it is a unique number
can this be done ? or am i chasing my tail
barcode number is 87964000000 for a sample and the check digit is 4
as for the calculations for the check digit i got the formula from the message boards here :-) thank you for that
Step Two: Sum all digits in odd position and multiply the result by 3. (8+9+4+0+0+0) * 3 = 63
Step Three: Sum all digits in even position. (7+6+0+0+0) = 13
Step Four: Sum the results of step three and four: 63+13 = 76
Step Five: Divide the result of step four by 10. 76 / 10 = 7.6 the 10 - 6 = 4
The check digit is the number which adds the remainder to 10.
In our case, divide 76 by 10 we get the remainder 6
The check digit then is the result of 10 - 6 = 4
hope this makes some sense to someone for help thanks in advance
peace be with you
Screen Shot 2021-05-13 at 2.51.38 PM.png
Bookmarks