How to calculate the UPC Check Digits

[David]

Hi,

We are trying to figure out how to calculate the UPC check digits? Is there
a formula for this calculation? For an example, on cell A1 we enter
74758551488 then A2 will calculate the digit.

Greatly appreciate any helps on this in advance!

 

[Gord Dibben]

This thread might help?

http://snipurl.com/1l4bw


Gord Dibben MS Excel MVP

 

[JE McGimpsey]

You can find a number of methods in the archives.

Go to http://groups.google.com/advanced_group_search?

and enter

UPC Check Digit

in the Find Messages with all of the words input box, and

*excel*

in the group input box

 

[David]

Thank you very much!!!

 

[Thomas Lutz]

From the right to left sum all digits in odd positions and multiply
the result by 3.
Sum all digits in even position.
Sum the results from the above two steps and do a MOD 10 on the total.
The check digit is the number which when added to the remainder equals
10.