•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#UPC-A
#check digit
#function
#Libreoffice
#calc
#Excel
#barcode
#MOD
#SUM
#WRAPROWS
#REGEXEXTRACT
#REPT
#LEN
#A1