Hi Guys, is there anyone know modulus 11 excel formulae to generate 7th digit.
Please see below formulae that i tried and it didn't work.
=MOD(SUM(B1:G1*B2:G2),11)=0
Below is Actual calculation.
Example: find the check digit for the number 036532
<tbody>
3
6
5
3
2
x7
x6
x5
x4...