用excel校验身份证号码

最新推荐文章于 2025-09-27 12:56:57 发布

原创最新推荐文章于 2025-09-27 12:56:57 发布 · 5.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#excel #java #前端

通过计算最后一位校验码，来判断身份证号是否正确。

=IF(LOOKUP(MOD(MID(D2,1,1)*7+MID(D2,2,1)*9+MID(D2,3,1)*10+MID(D2,4,1)*5+MID(D2,5,1)*8+MID(D2,6,1)*4+MID(D2,7,1)*2+MID(D2,8,1)*1+MID(D2,9,1)*6+MID(D2,10,1)*3+MID(D2,11,1)*7+MID(D2,12,1)*9+MID(D2,13,1)*10+MID(D2,14,1)*5+MID(D2,15,1)*8+MID(D2,16,1)*4+MID(D2,17,1)*2,11),{0;1;2;3;4;5;6;7;8;9;10},{"1";"0";"X";"9";"8";"7";"6";"5";"4";"3";"2"})=UPPER(MID(D2,18,1)),"正确","错误")

=IF(LOOKUP(MOD(MID(D2,1,1)*7+MID(D2,2,1)*9+MID(D2,3,1)*10+MID(D2,4,1)*5+MID(D2,5,1)*8+MID(D2,6,1)*4+MID(D2,7,1)*2+MID(D2,8,1)*1+MID(D2,9,1)*6+MID(D2,10,1)*3+MID(D2,11,1)*7+MID(D2,12,1)*9+MID(D2,13,1)*10+MID(D2,14,1)*5+MID(D2,15,1)*8+MID(D2,16,1)*4+MID(D2,17,1)*2,11),{0;1;2;3;4;5;6;7;8;9;10},{"1";"0";"X";"9";"8";"7";"6";"5";"4";"3";"2"})=UPPER(MID(D2,18,1)),"正确","错误")