=if(len(F_20)<>18,FALSE,IF(CHOOSE(MOD(SUM((MID(F_20,1,1)+MID(F_20,11,1))*7+(MID(F_20,2,1)+MID(F_20,12,1))*9+(MID(F_20,3,1)+MID(F_20,13,1))*10+(MID(F_20,4,1)+MID(F_20,14,1))*5+(MID(F_20,5,1)+MID(F_20,15,1))*8+(MID(F_20,6,1)+MID(F_20,16,1))*4+(MID(F_20,7,1)+MID(F_20,17,1))*2+MID(F_20,8,1)+MID(F_20,9,1)*6+MID(F_20,10,1)*3),11)+1,1,0,"X",9,8,7,6,5,4,3,2)=VALUE(RIGHT(F_20,1)),TRUE,FALSE))


F_20为身份证所在单元格。

很好用 支持一下！

在我这如果最后一位是X则不能正确判断，没分析具体原因，自己修改一下红色部分，问题解决

=IF(LEN(G10)<>18,FALSE,IF(CHOOSE(MOD(SUM((MID(G10,1,1)+MID(G10,11,1))*7+(MID(G10,2,1)+MID(G10,12,1))*9+(MID(G10,3,1)+MID(G10,13,1))*10+(MID(G10,4,1)+MID(G10,14,1))*5+(MID(G10,5,1)+MID(G10,15,1))*8+(MID(G10,6,1)+MID(G10,16,1))*4+(MID(G10,7,1)+MID(G10,17,1))*2+MID(G10,8,1)+MID(G10,9,1)*6+MID(G10,10,1)*3),11)+1,"1","0","X","9","8","7","6","5","4","3","2")=RIGHT(G10,1),TRUE,FALSE))

很好用 支持一下！

在我这如果最后一位是X则不能正确判断，没分析具体原因，自己修改一下红色部分，问题解决

=IF(LEN(G10)<>18,FALSE,IF(CHOOSE(MOD(SUM((MID(G10,1,1)+MID(G10,11,1))*7+(MID(G10,2,1)+MID(G10,12,1))*9+(MID(G10,3,1)+MID(G10,13,1))*10+(MID(G10,4,1)+MID(G10,14,1))*5+(MID(G10,5,1)+MID(G10,15,1))*8+(MID(G10,6,1)+MID(G10,16,1))*4+(MID(G10,7,1)+MID(G10,17,1))*2+MID(G10,8,1)+MID(G10,9,1)*6+MID(G10,10,1)*3),11)+1,"1","0","X","9","8","7","6","5","4","3","2")=RIGHT(G10,1),TRUE,FALSE))