Can somebody break down the below formula in layman's terms please? I need to provide instructions on how to build this, but I don't understand it.
=MOD(10-MOD(SUM(2*(CODE(MID(B2,1,1))-48)-9*INT((CODE(MID(B2,1,1))-48)/5),CODE(MID(B2,2,1))-48,2*(CODE(MID(B2,3,1))-48)-9*INT((CODE(MID(B2,3,1))-48)/5),CODE(MID(B2,4,1))-48,2*(CODE(MID(B2,5,1))-48)-9*INT((CODE(MID(B2,5,1))-48)/5),CODE(MID(B2,6,1))-48,2*(CODE(MID(B2,7,1))-48)-9*INT((CODE(MID(B2,7,1))-48)/5),CODE(MID(C2,1,1))-48,2*(CODE(MID(C2,2,1))-48)-9*INT((CODE(MID(C2,2,1))-48)/5),CODE(MID(C2,3,1))-48,2*(CODE(MID(D2,1,1))-48)-9*INT((CODE(MID(D2,1,1))-48)/5),CODE(MID(E2,1,1))-48,2*(CODE(MID(E2,2,1))-48)-9*INT((CODE(MID(E2,2,1))-48)/5)),10),10)
Thank you!
Bookmarks