View original (French)

EAN-13 barcode check digit

Solved
Anonymous user -  
 CorentinPL -
Hi,
I need a little information.
Does anyone know how the check digit of an EAN-13 barcode is calculated??

Thank you

8 réponses

Réponse 1 / 8
Eddy.vh
 
Hello.

If you have the first 12 characters of your EAN code in cell A1, in B1 you can use the following formula:

=MOD(10-SUM(MID(B1,{2;4;6;8;10;12},1)*3+MID(B1,{1;3;5;7;9;11},1)),10)

This performs the necessary calculation…

And to have the complete EAN in cell B2 for quick copy/pasting, the following formula will be useful:

=A1&MOD(10-SUM(MID(G7,{2;4;6;8;10;12},1)*3+MID(G7,{1;3;5;7;9;11},1)),10)

If you have a list of codes, simply place the formula in the first cell and drag the fill handle down…
24
Eddy.vh
 
Oops, I forgot an "s" in the first 12

And the G7s need to be changed to B1 in the second formula, where was my head?
0
CorentinPL
 
Thank you thank you thank you! For your information: write the first 12 digits of the EAN13 (without the check digit) in cell A1 and write Eddy's code as follows:
[Calculation of the check digit only]
=MOD(10-SUM(MID(A1,{2;4;6;8;10;12},1)*3+MID(A1,{1;3;5;7;9;11},1));10)
or
[Calculation of the entire code (12&check digit)]
=A1&MOD(10-SUM(MID(A1,{2;4;6;8;10;12},1)*3+MID(A1,{1;3;5;7;9;11},1));10)
a+
-1