excel身份證校驗公式?身份讓證号驗證,隻需收藏起來,用時把c4替換就ok，今天小編就來聊一聊關于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}),"正确","不正确")
,更多精彩资讯请关注tft每日頭條，我们将持续为您更新最新资讯!
zpostcode 
Recruit 
weather 
mreligion 
Yellowpages 
sport 
constellation 
shopping 
name 
game 
directory 
literature 
Word 
tour 
furnish 
Lottery 
tftnews 
lyrics 
News 
digital 
car 
dir 
Edu 
Finance 
