Excel Ideas and Topics
Check Digit Calculation in Excel
Rather than recreate a page I have already prepared for my blog, here is the link to a page on creating and verifying a check digit using Excel.
This page is interesting by itself but then when you read about the challenges I faced with SUMPRODUCT() and how I used array constants, INT(), LEFT(), MID() as we as SUM, yoiu might start to appreciate that all is not what it seems!
Go to the Check Digit Page
Download my Excel file from there too
This is the entire page but as an image
(C) Copyright Duncan Williamson www.duncanwil.co.uk 2015