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