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,"缺号码","位数不对!")))