第二代居民身份证号码的校验码计算模型、步骤、公式

需要校验的身份证号码身份证号码前17位请在这里填写你需要校验的身份证号码乘以×××××××××××××××××2的n次方2172162152142132122112102928272625242322212n的实际值1310726553632768163848192409620481024512256128643216842÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷1111111111111111111111111111111111余余余余余余余余余余余余余余余余余(2n÷11)的余数7910584216379105842(号码×2n)的积①#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!(号码×余数)的积②#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!(①的和÷11)得余数#VALUE!÷11余#VALUE!最后得到校验码#VALUE!(②的和÷11)得余数#VALUE!÷11余#VALUE!最后得到校验码#VALUE!余数列表012345678910校验码对照表10X98765432第二代居民身份证号码的校验码计算模型请在这里填写你需要校验的身份证号码注：沿着红色箭头运算方向也可，沿着绿色箭头运算方向也可。需要校验的身份证号码号码前17位分解请在这里填写你需要校验的身份证号码n=18-位数17161514131211109876543212n1310726553632768163848192409620481024512256128643216842(2n÷11)的余数7910584216379105842(号码×余数)的积#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!乘积的和(和÷11)的余数余数列表012345678910校验码对照表10X98765432得到校验码通过校验的身份证号码校验前后的身份证号码是否相同#VALUE!#VALUE!#VALUE!第二代居民身份证号码的校验码计算步骤请在这里填写你需要校验的身份证号码#VALUE!#VALUE!①最原始的公式，逐个运算，便于理解=LEFT(D2,17)&LOOKUP(MOD(SUM(MID(D2,1,1)*MOD(2^17,11),MID(D2,2,1)*MOD(2^16,11),MID(D2,3,1)*MOD(2^15,11),MID(D2,4,1)*MOD(2^14,11),MID(D2,5,1)*MOD(2^13,11),MID(D2,6,1)*MOD(2^12,11),MID(D2,7,1)*MOD(2^11,11),MID(D2,8,1)*MOD(2^10,11),MID(D2,9,1)*MOD(2^9,11),MID(D2,10,1)*MOD(2^8,11),MID(D2,11,1)*MOD(2^7,11),MID(D2,12,1)*MOD(2^6,11),MID(D2,13,1)*MOD(2^5,11),MID(D2,14,1)*MOD(2^4,11),MID(D2,15,1)*MOD(2^3,11),MID(D2,16,1)*MOD(2^2,11),MID(D2,17,1)*MOD(2^1,11)),11),{0;1;2;3;4;5;6;7;8;9;10},{1;0;X;9;8;7;6;5;4;3;2})②将公式①的(2n÷11取余)去掉，只留2n=LEFT(D2,17)&LOOKUP(MOD(SUM(MID(D2,1,1)*2^17,MID(D2,2,1)*2^16,MID(D2,3,1)*2^15,MID(D2,4,1)*2^14,MID(D2,5,1)*2^13,MID(D2,6,1)*2^12,MID(D2,7,1)*2^11,MID(D2,8,1)*2^10,MID(D2,9,1)*2^9,MID(D2,10,1)*2^8,MID(D2,11,1)*2^7,MID(D2,12,1)*2^6,MID(D2,13,1)*2^5,MID(D2,14,1)*2^4,MID(D2,15,1)*2^3,MID(D2,16,1)*2^2,MID(D2,17,1)*2^1),11),{0;1;2;3;4;5;6;7;8;9;10},{1;0;X;9;8;7;6;5;4;3;2})③将公式①的LookUp函数换成Mid函数=LEFT(D2,17)&MID(10X98765432,MOD(SUM(MID(D2,1,1)*MOD(2^17,11),MID(D2,2,1)*MOD(2^16,11),MID(D2,3,1)*MOD(2^15,11),MID(D2,4,1)*MOD(2^14,11),MID(D2,5,1)*MOD(2^13,11),MID(D2,6,1)*MOD(2^12,11),MID(D2,7,1)*MOD(2^11,11),MID(D2,8,1)*MOD(2^10,11),MID(D2,9,1)*MOD(2^9,11),MID(D2,10,1)*MOD(2^8,11),MID(D2,11,1)*MOD(2^7,11),MID(D2,12,1)*MOD(2^6,11),MID(D2,13,1)*MOD(2^5,11),MID(D2,14,1)*MOD(2^4,11),MID(D2,15,1)*MOD(2^3,11),MID(D2,16,1)*MOD(2^2,11),MID(D2,17,1)*MOD(2^1,11)),11)+1,1)④将公式②的LookUp函数换成Mid函数=LEFT(D2,17)&MID(10X98765432,MOD(SUM(MID(D2,1,1)*2^17,MID(D2,2,1)*2^16,MID(D2,3,1)*2^15,MID(D2,4,1)*2^14,MID(D2,5,1)*2^13,MID(D2,6,1)*2^12,MID(D2,7,1)*2^11,MID(D2,8,1)*2^10,MID(D2,9,1)*2^9,MID(D2,10,1)*2^8,MID(D2,11,1)*2^7,MID(D2,12,1)*2^6,MID(D2,13,1)*2^5,MID(D2,14,1)*2^4,MID(D2,15,1)*2^3,MID(D2,16,1)*2^2,MID(D2,17,1)*2^1),11)+1,1)⑤将公式①变为数组公式，按Ctrl+Shift+Enter组合键=LEFT(D2,17)&LOOKUP(MOD(SUM(MID(D2,ROW(INDIRECT(1:17)),1)*MOD(2^(18-ROW(INDIRECT(1:17))),11)),11),{0;1;2;3;4;5;6;7;8;9;10},{1;0;X;9;8;7;6;5;4;3;2})⑥将公式②变为数组公式，按Ctrl+Shift+Enter组合键=LEFT(D2,17)&LOOKUP(MOD(SUM(MID(D2,ROW(INDIRECT(1:17)),1)*2^(18-ROW(INDIRECT(1:17)))),11),{0;1;2;3;4;5;6;7;8;9;10},{1;0;X;9;8;7;6;5;4;3;2})⑦将公式③变为数组公式，按Ctrl+Shift+Enter组合键=LEFT(D2,17)&MID(10X98765432,MOD(SUM(MID(D2,ROW(INDIRECT(1:17)),1)*MOD(2^(18-ROW(INDIRECT(1:17))),11)),11)+1,1)⑧将公式④变为数组公式，按Ctrl+Shift+Enter组合键=LEFT(D2,17)&MID(10X98765432,MOD(SUM(MID(D2,ROW(INDIRECT(1:17)),1)*2^(18-ROW(INDIRECT(1:17)))),11)+1,1)普通公式数组公式第二代居民身份证号码的校验码计算公式注：上述⑧个公式，用任何一个都可以，校验结果是一致的。使用时，需要将公式中的D2全部替换为相应单元格名称。