Thanks very much David.
Interesting that the exact link to the Customs in-bond entry check-digit
calculator was the source of my question. I' glad you recognized the
question.
Best regards

"David Biddulph" wrote:

.... or more likely
=ROUNDUP(ROUNDDOWN(MOD(A1/7,1),1)*7,0)

Examples are shown at
http://www.cbp.gov/linkhandler/cgov/...nd_check.docor http://www.ecustoms.com/vg/QPWP-reso...eck.cfm--David Biddulph"JE McGimpsey" wrote in ... If I understand you correctly: =ROUNDUP(ROUND(MOD(A1/7,1),1)*7,0) In article , Dan wrote: My math skills are deficient. I've tried to work with 4 different formulas provided for othercheck-digit makers, but my source number is 8 digits, and while it's a simplerformula, I can't figure it out based on the other formulas: Step 1 - divide the 8-digit number by 7; Step 2 - multiply the remainder by 7. (If the remainder is more than one digit, use only the first digit; Step 3, Round that answer up to the next whole number. This is the check digit Note: If the remainder is zero, it is a
whole number. Do not round up. Zero is the check-digit. Any help ??? Thanks in advance ...