G
Guest
Guest
I'm trying to set up a simple spreadhseet so our payment clerks can enter a cheque number and have it auto-generate the self-check cheque digit.
The bank says its as follows : "the digit is based on modulus 10, weighting 731731"
apparently cheque number 535644 will have a last digit of 7 based on the above logic, but my spreadhseet won't agree....
is anyone familiar with what I ought to be doing ? I'm looking at each digit and multiplying by the weighting, then adding the sum of the resulting digits and deducting it from the next multiple of 10 to get a remainder but it's not working out
Any takers ?
cheers
Chris
The bank says its as follows : "the digit is based on modulus 10, weighting 731731"
apparently cheque number 535644 will have a last digit of 7 based on the above logic, but my spreadhseet won't agree....
is anyone familiar with what I ought to be doing ? I'm looking at each digit and multiplying by the weighting, then adding the sum of the resulting digits and deducting it from the next multiple of 10 to get a remainder but it's not working out
Any takers ?
cheers
Chris