Forum Discussion

GregGreg2's avatar
GregGreg2
Qrew Member
11 years ago

How to calculate a UPC check digit in QuickBase?

The last digit of a bar code number is a computer check digit which makes sure the bar code is correctly composed. The final digit of a Universal Product Code is a check digit computed as follows: ...
Data import and export
Formulas and functions
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
11 years ago
Assuming you have the digits broken down into individual numeric fields ([1], [2], ... [12]) here is the formula for the check field digit (ie [12]):

10 - Mod( 3 * ( [1] + [3] + [5] + [7] + [9] +[11]) + [2] + [4] + [6] + [8] + [10] , 10 )


See:

http://en.wikipedia.org/wiki/Check_digit#UPC