Carl
E3 is the cell with the complete number (with check digit).
(You should change that to A3)
The formula goes in C3 to the right.
I also added: =IF(VALUE(RIGHT(A3))=C3,"OK","error") which compares the last
digit in A3 to the calculated check-digit... If the chkdigit is correct, you
see 'OK'
I can't attach worksheets here...
To: cmcmillan3 <
Priority: normal
From: Earl Wertheimer <
Date sent: Thu, 01 Jun 2006 09:49:18 -0400
Subject: Re: [
EDI-L] GTIN Generated from UPC
> Carl
>
> =MOD(10-MOD(SUMPRODUCT(--(MID(E3,{1,3,5,7,9,11},1)))*3+SUMPRODUCT(--
> (MID(E3,{2,4,6,8,10},1))),10),10)
>
> is the formula for the UPC checkdigit (12 digits)
>
> Just add digits 12 & 13 (to the even/odd sections)
>
> =MOD(10-MOD(SUMPRODUCT(--(MID(E3,{1,3,5,7,9,11,13},1)))*3+SUMPRODUCT(--
> (MID(E3,{2,4,6,8,10,12},1))),10),10)
>
> There are probably some on-line
tools that you can use to check the
> calculation...
>
>
>
> To:
> From: "cmcmillan3" <
> Date sent: Thu, 01 Jun 2006 12:56:23 -0000
> Subject: [
EDI-L] GTIN Generated from UPC
>
> > Does anyone have a tool or know the math to create a GTIN based on a
> > UPC code? I had a little utitlity that did this in Excel but I cannot
> > find it. I need to create 3 GTIN's and am going crazy.
> > Any help is appreciated.
> > -Carl
> >
> >
> >
> >
> >
> >
> > ...
> > Please use the following Message Identifiers as your subject prefix:
<
SALES>,
> > <
JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
> >
> > Job postings are welcome, but for job postings or requests for work: <JOBS>
IS
> > REQUIRED in the subject line as a prefix.
> >
> > Access the list online at: http://groups.yahoo.com/group/EDI-L
> >
RSS feed is: http://rss.groups.yahoo.com/group/EDI-L/rss
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > __________ NOD32 1.1572 (20060601) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.eset.com
> >
> >
>
> Earl Wertheimer
>
> http://www.spe-edi.com
>
>
>
>
> ...
> Please use the following Message Identifiers as your subject prefix: <SALES>,
> <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
>
> Job postings are welcome, but for job postings or requests for work: <JOBS> IS
> REQUIRED in the subject line as a prefix.
>
> Access the list online at: http://groups.yahoo.com/group/EDI-L
> RSS feed is: http://rss.groups.yahoo.com/group/EDI-L/rss
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.1572 (20060601) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
Earl Wertheimer
http://www.spe-edi.com
Cart
