Barcode suffix ean128

[Kurt EAN128]

Hello
Can someone help me with a formula to generate the last digit of my barcode
string. ean128 (13+1 digits))

as in eksample.

A1=1234567890123
B1= "formula to generate" = "1234567890123 1" (1 is generated)
C1="B1 barcode print font (need help with this also

This site does generate code http://www.gs1.no/kontrollsifferberegning/
but it takes a lot of time since i have to cut and paste each number.

Can anybody help?

 

[Bernard Liengme]

We need to be told the algorithm used.
Please confirm that this site gives the correct answer, then a formula can
be developed
http://www.ean-int.org/barcodes/support/check_digit_calculator
best wishes

 

[Bernard Liengme]

Using the algorithm from

and

I have come with this formula
=10-MOD(SUMPRODUCT(VALUE(MID(A1,ROW($A$1:$A$13),1)),{3;1;3;1;3;1;3;1;3;1;3;1;3}),10)

where A1 is the cell holding the 13-digit number. Do not change A1:A13 -
this gets the numbers {1,2,3...} Do not alter semicolons ; to commas, since
I am working in rows not columns

This formula incorrectly give 10 when the SUMPROUDCT part evaluates to zero.
SO we need to modify the formula to

=MOD(10-MOD(SUMPRODUCT(VALUE(MID(A1,ROW($A$1:$A$13),1)),{3;1;3;1;3;1;3;1;3;1;3;1;3}),10),10)

The trouble with using ROW is that someone might insert a reo into the
worksheet and this will mess up the formula. Here is an alternative
=MOD(10-MOD(SUMPRODUCT(VALUE(MID(A1,{1;2;3;4;5;6;7;8;9;10;11;12;13},1)),{3;1;3;1;3;1;3;1;3;1;3;1;3}),10),10)

best wishes

 

[John]

Hi Bernard
This site shows you how to calculate what I think the OP is looking for (
EAN/UCC 14 ) not EAN128: http://www.morovia.com/education/utility/upc-ean.asp,
just scroll down to EAN/UCC14, you will see the calculation.
If the OP can confirm.
Regards
John

 

[Bernard Liengme]

Forgot to give sites for algorithm
http://www.usps.com/cpim/ftp/pubs/pub97/97apxs_006.html#_Toc481397334
http://www.ean-int.org/barcodes/support/check_digit_calculator