ShoesNBlues
New Member
- Joined
- Oct 19, 2006
- Messages
- 15
Hi!
I'm having a bit of a problem figuring out a formula for this:
-The spreadsheet I'm putting together is to automate 17-digit UCC numbers + their check digits. The formula to find the check digit is to add all of the digits in odd position then multiply by 3, then add all of the evens, then add the two products together; the check digit is what it takes to round up to the nearest 10. I figured that formula out with a little trial and error.
-What I had to do, because of the even and odd positions, was to put each digit in its own cell.
-I don't want to have to manually enter every digit into each individual cell, so I tried to concatenate, which kind of works, but not really because it returns the entire number, not one digit per cell.
Anybody have any idea how to do this?
Thanks!
I'm having a bit of a problem figuring out a formula for this:
-The spreadsheet I'm putting together is to automate 17-digit UCC numbers + their check digits. The formula to find the check digit is to add all of the digits in odd position then multiply by 3, then add all of the evens, then add the two products together; the check digit is what it takes to round up to the nearest 10. I figured that formula out with a little trial and error.
-What I had to do, because of the even and odd positions, was to put each digit in its own cell.
-I don't want to have to manually enter every digit into each individual cell, so I tried to concatenate, which kind of works, but not really because it returns the entire number, not one digit per cell.
Anybody have any idea how to do this?
Thanks!