Excel 身份证验证公式

Excel 身份证验证公式

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