快速识别身份证号码准确性:Excel公式的智能检测技巧

=IF(LEN(A1)=18,IF(RIGHT(A1,1)="X",IF(CHOOSE(MOD(SUM(LEFT(RIGHT(A1,18))*7+LEFT(RIGHT(A1,17))*9+LEFT(RIGHT(A1,16))*10+LEFT(RIGHT(A1,15))*5+LEFT(RIGHT(A1,14))*8+LEFT(RIGHT(A1,13))*4+LEFT(RIGHT(A1,12))*2+LEFT(RIGHT(A1,11))*1+LEFT(RIGHT(A1,10))*6+LEFT(RIGHT(A1,9))*3+LEFT(RIGHT(A1,8))*7+LEFT(RIGHT(A1,7))*9+LEFT(RIGHT(A1,6))*10+LEFT(RIGHT(A1,5))*5+LEFT(RIGHT(A1,4))*8+LEFT(RIGHT(A1,3))*4+LEFT(RIGHT(A1,2))*2),11)+1,1,0,"X",9,8,7,6,5,4,3,2)=LEFT(RIGHT(A1,1)),"正确","错误"),IF(CHOOSE(MOD(SUM(LEFT(RIGHT(A1,18))*7+LEFT(RIGHT(A1,17))*9+LEFT(RIGHT(A1,16))*10+LEFT(RIGHT(A1,15))*5+LEFT(RIGHT(A1,14))*8+LEFT(RIGHT(A1,13))*4+LEFT(RIGHT(A1,12))*2+LEFT(RIGHT(A1,11))*1+LEFT(RIGHT(A1,10))*6+LEFT(RIGHT(A1,9))*3+LEFT(RIGHT(A1,8))*7+LEFT(RIGHT(A1,7))*9+LEFT(RIGHT(A1,6))*10+LEFT(RIGHT(A1,5))*5+LEFT(RIGHT(A1,4))*8+LEFT(RIGHT(A1,3))*4+LEFT(RIGHT(A1,2))*2),11)+1,1,0,"X",9,8,7,6,5,4,3,2)=LEFT(RIGHT(A1,1))*1,"正确","错误")),IF(LEN(A1)=15,"老号，请注意！",IF(LEN(A1)=0,"未填写身份证号码","位数不对！")))

直接复制如上公式进入单元格，可根据提示进行身份证号码的修改。