reggie k
New Member
- Joined
- Nov 7, 2012
- Messages
- 15
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>
</tbody>0 + 18 + 30 + 20 + 9 + 4 = 81
81/11 = 7 remainder 4
11 - 4 = 7
7 is therefore the check 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
3 | 6 | 5 | 3 | 2 | |
x7 | x6 | x5 | x4 | x3 | x2 |
18 | 30 | 20 | 9 | 4 |
<tbody>
</tbody>
81/11 = 7 remainder 4
11 - 4 = 7
7 is therefore the check digit.