excel 身份證號校驗公式

身份讓證號驗證,只需收藏起來,用時把c4替換就ok。

=IF(C4=MID(C4,1,17)&LOOKUP(MOD(MID(MID(C4,1,17),1,1)*7+MID(MID(C4,1,17),2,1)*9+MID(MID(C4,1,17),3,1)*10+MID(MID(C4,1,17),4,1)*5+MID(MID(C4,1,17),5,1)*8+MID(MID(C4,1,17),6,1)*4+MID(MID(C4,1,17),7,1)*2+MID(MID(C4,1,17),8,1)*1+MID(MID(C4,1,17),9,1)*6+MID(MID(C4,1,17),10,1)*3+MID(MID(C4,1,17),11,1)*7+MID(MID(C4,1,17),12,1)*9+MID(MID(C4,1,17),13,1)*10+MID(MID(C4,1,17),14,1)*5+MID(MID(C4,1,17),15,1)*8+MID(MID(C4,1,17),16,1)*4+MID(MID(C4,1,17),17,1)*2,11),{0,1;1,0;2,“x”;3,9;4,8;5,7;6,6;7,5;8,4;9,3;10,2}),“正確”,“不正確”)