Currently I am using this formula for UPC code generating. But the problem is I have all digit 11 cells. Is there anyway to combine into cell. Here is the formula.
Ok, I'm finally with you, and I think I have what you want
1) Enter in cell A1: 26826812345
2) Enter in cells B1->J1: =MID(A1, X, 1), where X = 1 for ColB, 2 for ColC, etc.
3) Enter in Cell M1: Your Mod Formula =MOD(10-(MOD(((B1+D1+F1+H1+J1+L1)*3)+(C1+E1+G1+I1+K1),10)),10)
Step 2 tells Excel to find the number in position X in A1 and put it in the appropriate column.
My formula is used to generate UPC code. I follow this sample code accepts to calculates the check digit, and returns the finished string. The general method involves adding up the digits in the odd-numbered positions and multiplying that sum by 3; then adding to that result the values of the digits in the even-numbered positions. Divide this result by 10 and subtract the remainder from 10. If the result is equal to 10, set it to zero; otherwise this is the check digit.
Because I don't know how to put forumla in odd number positions and even number positions. May be you reading the about requirement you can put into a formula.
1) Enter in cell A1: 26826812345
2) Enter in cells B1->L1: =MID(A1, X, 1), where X = 1 for ColB, 2 for ColC, etc.
3) Enter in Cell M1: Your Mod Formula =MOD(10-(MOD(((B1+D1+F1+H1+J1+L1)*3)+(C1+E1+G1+I1+K1),10)),10)
1) takes a UPC code from cell A1
2) breaks it up into 11 cells (B1->L1)
3) and then checks the validity of the UPC code via your formula in cell M1. if cell M1 = 0, then you have a valid UPC code.
The assumption I made here was that you actually had data to enter into cell A1. Are you saying that you DON'T have a UPC? Your earlier posts say that you want to generate a UPC code -- but I don't see why you provided a UPC number (26826812345).
Sorry making it so confusing, I attached the excel sheet for you to check.
Basically I like to be able to create consenstive number in column A and generative UPC code on column E.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.