LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default How do I calculate a check-digit in Excel?

My math skills are deficient.
I've tried to work with 4 different formulas provided for other check-digit
makers, but my source number is 8 digits, and while it's a simpler formula, 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 ...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I Calculate Check Digit for UPC A - the 13th warrior AIRJACK Excel Discussion (Misc queries) 6 May 4th 23 07:46 PM
Creating a Check Digit Ilan Charts and Charting in Excel 1 December 3rd 05 12:43 PM
Mod-10 Check Digit Union70 Excel Worksheet Functions 1 March 24th 05 11:35 PM
Mod-10 Check Digit Union70 Excel Worksheet Functions 4 March 8th 05 07:58 AM
Excel should have a function to verify the check digit on UPC num. Brian S B Excel Discussion (Misc queries) 1 February 1st 05 08:27 PM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"