1、建立表格
2、系数
7
9
10
5
8
4
2
1
6
3
7
9
10
5
8
4
2
3、第18位盲婶身份证号宋伐拒
1
0
X
9
8
7
6
5
4
3
2
4、B2输入公式畜互
=LEFT(A2,6)&"19"&MID(A2,7,9)&VLOOKUP(MOD(MID(A2,1,1)*D2+MID(A2,2,1)*D3+MID(A2,3,1)*D4+MID(A2,4,1)*D5+MID(A2,5,1)*D6+MID(A2,6,1)*D7+1*D8+9*D9+MID(A2,7,1)*D10+MID(A2,8,1)*D11+MID(A2,9,1)*D12+MID(A2,10,1)*D13+MID(A2,11,1)*D14+MID(A2,12,1)*D15+MID(A2,13,1)*D16+MID(A2,14,1)*D17+MID(A2,15,1)*D18,11),E:F,2,0)