GTIN Calculator in Excel
GTIN Calculation is basically of different types like GTIN 8, GTIN 12, GTIN 13 and GTIN 14. We can calculate GTIN by using Excel Formula as well as Excel Macro.
GTIN Calculator By Formula | GTIN Calculator By Macro | How to Calculate GTIN | Download GTIN Calculator
GTIN Calculation- By Excel Formula:
VBA Code to Calculate GTIN
Sub gtin_cal(normal) Dim n Dim n1, n2, n3, n4, n5, n6, n7, n8, n9, n10, n11, n12 n1 = CInt(Mid(normal, 1, 1)) n2 = CInt(Mid(normal, 2, 1)) n3 = CInt(Mid(normal, 3, 1)) n4 = CInt(Mid(normal, 4, 1)) n5 = CInt(Mid(normal, 5, 1)) n6 = CInt(Mid(normal, 6, 1)) n7 = CInt(Mid(normal, 7, 1)) n8 = CInt(Mid(normal, 8, 1)) n9 = CInt(Mid(normal, 9, 1)) n10 = CInt(Mid(normal, 10, 1)) n11 = CInt(Mid(normal, 11, 1)) n12 = CInt(Mid(normal, 12, 1)) n = (n1 + n3 + n5 + n7 + n9 + n11) + (n2 + n4 + n6 + n8 + n10 + n12) * 3 q = Int(n / 10) r = n Mod 10 If (r <> 0) Then append_value = (10 * (q + 1)) - n Else append_value = 0 End If gtin_val = "0" & normal & CStr(append_value) End Sub
How to Calculate GTIN
|Step 1: Multiply value of each position by 1 0 3 as mentioned below for each of the GTIN|
|Step 2: Add results together to create sum|
|Step 3: Subtract the sum from nearest equal or higher multiple of ten = Check Digit|
|Step 4: Now Append the Check Digit at the End of the Number. Also we need to make the complete Number of 14 Digit, So append the remaining digits as Zero as a Prefix.|
Download this GTIN Calculator
I have created one Excel Workbook which can calculate all types of GTIN. If you want all GTIN calculator in Excel, download by clicking on the below download button.
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P
AND GET A FREE!
E-BOOK FOR EXCEL VBA BEGINNERS
DON'T MISS ANY NEW ARTICLE !
Get your FREE! E-Book & Have Every New Article Delivered Straight To Your Email-Box