身份证校验公式
=IF(LEN(D1)=18,IF(RIGHT(D1,1)="X",IF(CHOOSE(MOD(SUM(LEFT(RIGHT(D1,18))*7+LEFT(RIGHT(D1,17))*9+LEFT(RIGHT(D1,16))*10+LEFT(RIGHT(D1,15))*5+LEFT(RIGHT(D1,14))*8+LEFT(RIGHT(D1,13))*4+LEFT(RIGHT(D1,12))*2+LEFT(RIGHT(D1,11))*1+LEFT(RIGHT(D1,10))*6+LEFT(RIGHT(D1,9))*3+LEFT(RIGHT(D1,8))*7+LEFT(RIGHT(D1,7))*9+LEFT(RIGHT(D1,6))*10+LEFT(RIGHT(D1,5))*5+LEFT(RIGHT(D1,4))*8+LEFT(RIGHT(D1,3))*4+LEFT(RIGHT(D1,2))*2),11)+1,1,0,"X",9,8,7,6,5,4,3,2)=LEFT(RIGHT(D1,1)),"正确!","出错啦!"),IF(CHOOSE(MOD(SUM(LEFT(RIGHT(D1,18))*7+LEFT(RIGHT(D1,17))*9+LEFT(RIGHT(D1,16))*10+LEFT(RIGHT(D1,15))*5+LEFT(RIGHT(D1,14))*8+LEFT(RIGHT(D1,13))*4+LEFT(RIGHT(D1,12))*2+LEFT(RIGHT(D1,11))*1+LEFT(RIGHT(D1,10))*6+LEFT(RIGHT(D1,9))*3+LEFT(RIGHT(D1,8))*7+LEFT(RIGHT(D1,7))*9+LEFT(RIGHT(D1,6))*10+LEFT(RIGHT(D1,5))*5+LEFT(RIGHT(D1,4))*8+LEFT(RIGHT(D1,3))*4+LEFT(RIGHT(D1,2))*2),11)+1,1,0,"X",9,8,7,6,5,4,3,2)=LEFT(RIGHT(D1,1))*1,"正确!","出错啦!")),IF(LEN(D1)=15,"老号,请注意!",IF(LEN(D1)=0,"缺号码","位数不对!")))
D列为身份证号码数据,前面要加 '
本公式可以校验所有的身份证号码
file:///D://My%20Documents//My%20Pictures//7.jpg
|