身份证效验规则

fanjun_726 · 发表于 2023-8-29 10:54

感谢楼主分享

ziranl · 发表于 2023-8-30 14:24

谢谢楼主分享

周波 · 发表于 2023-8-30 16:17

这个感觉有点差

mjg18883645732 · 发表于 2023-9-18 22:02

本帖最后由 mjg18883645732 于 2023-9-18 22:04 编辑

=IF(TEXT(IF(MOD(12-(MID(A1,1,1)*7+MID(A1,2,1)*9+MID(A1,3,1)*10+MID(A1,4,1)*5+MID(A1,5,1)*8+MID(A1,6,1)*4+MID(A1,7,1)*2+MID(A1,8,1)*1+MID(A1,9,1)*6+MID(A1,10,1)*3+MID(A1,11,1)*7+MID(A1,12,1)*9+MID(A1,13,1)*10+MID(A1,14,1)*5+MID(A1,15,1)*8+MID(A1,16,1)*4+MID(A1,17,1)*2),11)=10,"X",MOD(12-(MID(A1,1,1)*7+MID(A1,2,1)*9+MID(A1,3,1)*10+MID(A1,4,1)*5+MID(A1,5,1)*8+MID(A1,6,1)*4+MID(A1,7,1)*2+MID(A1,8,1)*1+MID(A1,9,1)*6+MID(A1,10,1)*3+MID(A1,11,1)*7+MID(A1,12,1)*9+MID(A1,13,1)*10+MID(A1,14,1)*5+MID(A1,15,1)*8+MID(A1,16,1)*4+MID(A1,17,1)*2),11)),0)=MID(A1,18,1),"对","错")这个直接放到单元格就可以判断了，A1就是身份证号码