Excel表格验证身份证号输入规范

=IF(COUNTBLANK(C3),"",IFERROR(IF(LOOKUP((LEFT(C3,1)*7+MID(C3,2,1)*9+MID(C3,3,1)*10+MID(C3,4,1)*5+MID(C3,5,1)*8+MID(C3,6,1)*4+MID(C3,7,1)*2+MID(C3,8,1)+MID(C3,9,1)*6+MID(C3,10,1)*3+MID(C3,11,1)*7+MID(C3,12,1)*9+MID(C3,13,1)*10+MID(C3,14,1)*5+MID(C3,15,1)*8+MID(C3,16,1)*4+MID(C3,17,1)*2)-ROUNDDOWN((LEFT(C3,1)*7+MID(C3,2,1)*9+MID(C3,3,1)*10+MID(C3,4,1)*5+MID(C3,5,1)*8+MID(C3,6,1)*4+MID(C3,7,1)*2+MID(C3,8,1)+MID(C3,9,1)*6+MID(C3,10,1)*3+MID(C3,11,1)*7+MID(C3,12,1)*9+MID(C3,13,1)*10+MID(C3,14,1)*5+MID(C3,15,1)*8+MID(C3,16,1)*4+MID(C3,17,1)*2)/11,0)*11,{0,1,2,3,4,5,6,7,8,9,10},{"1","0","x","9","8","7","6","5","4","3","2"})=RIGHT(C3,1),"","身份证号码不正确"),"身份证号码不正确"))

以上的公示的意思是，假设身份证输入在了C3单元格里，如果输入为空，什么都不提示，如果输入了某值，则会校验符不符合身份证的格式，如果符合则什么都不提示，如果不符合则提示身份证号码不正确。

设置多个单元格时，只需拖拽公示即可。