Calculate UPC Check Digit in Excel

[jeffcomputers]

I tried all of these formulas and none work for our example from this page: https://www.mrexcel.com/forum/excel-questions/310146-calculating-upc-barcode-check-digits-3.html

I am using the GS1 as a guide, as they are the rules of bar

codes

Formula Name     Product Name     Partial UPC     Calculated Check Digit     New UPC     Correct Check Digit     Is Correct          https://www.gs1.org/services/check-digit-calculator 
Giant Formula - Pmfming     Monster Ultra Sunrise     7084702090     0     70847020900     5     FALSE           
Tiny Formula - jlarkin     Monster Ultra Sunrise     7084702090     7     70847020907     5     FALSE

Screenshot: https://imgur.com/ew1zX7x

Favorite formula, not working (Tiny Formula - jlarkin)
=MOD(-SUM(MID(TEXT(C3,"000000000000"),{1,3,5,7,9,11;2,4,6,8,10,12},1)*{3;1}),10)

 

[Tetra201]

Try

=MOD(-SUM(MID(TEXT(C3,"00000000000\0"),{1,3,5,7,9,11;2,4,6,8,10,12},1)*{3;1}),10)

 

[jeffcomputers]

That works great. Thanks. I am having trouble converting it to a Google Sheets formula. Any tips?

 

[Tetra201]

You are welcome.

No experience with Google Sheets -- maybe

=MOD(-SUM(MID(TEXT(C3,"00000000000")&0,{1,3,5,7,9,11;2,4,6,8,10,12},1)*{3;1}),10)

 

[jahurulislam]

You are welcome.

No experience with Google Sheets -- maybe

=MOD(-SUM(MID(TEXT(C3,"00000000000")&0,{1,3,5,7,9,11;2,4,6,8,10,12},1)*{3;1}),10)

I got something that works. We can use =MOD(-SUM(mmult({3,1}, arrayformula(VALUE(MID(TEXT(C3,"00000000000")&0,{1,3,5,7,9,11;2,4,6,8,10,12},1))))),10)