•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can’t figure out how to build UPC-a check digit function
So for work I need to build a function in Libreoffice calc or excel that can calculate a UPC-A barcode check digit. And I cannot for the life of me figure out that function
SOLVED:
=MOD(-SUM(WRAPROWS(--REGEXEXTRACT(REPT("0",18-LEN(A1))&A1,".",1),2,0)*{1,3}),10)
That is the function for an 11 digit upc-a
[link] [comments]
Want to read more?
Check out the full article on the original site