转载：EXCEL身份证号码校验公式

新身份证号码校验公式原文网址： http://www.excelpx.com/thread-189417-1-1.html

 

=IF(LEN(F2)=0,"空",IF(LEN(F2)=15,"老号",IF(LEN(F2)<>18,"位数不对",IF(CHOOSE(MOD(SUM(MID(F2,1,1)*7+MID(F2,2,1)*9+MID(F2,3,1)*10+MID(F2,4,1)*5+MID(F2,5,1)*8+MID(F2,6,1)*4+MID(F2,7,1)*2+MID(F2,8,1)*1+MID(F2,9,1)*6+MID(F2,10,1)*3+MID(F2,11,1)*7+MID(F2,12,1)*9+MID(F2,13,1)*10+MID(F2,14,1)*5+MID(F2,15,1)*8+MID(F2,16,1)*4+MID(F2,17,1)*2),11)+1,1,0,"X",9,8,7,6,5,4,3,2)= IF(ISNUMBER(RIGHT(F2,1)*1),RIGHT(F2,1)*1,"X"),"正确","错误"))))