Excel 身份证验证公式
Excel 身份证验证公式=IF(LEN(Y2)=18,IF(RIGHT(Y2,1)="X",IF(CHOOSE(MOD(SUM(LEFT(RIGHT(Y2,18))*7+LEFT(RIGHT(Y2,17))*9+LEFT(RIGHT(Y2,16))*10+LEFT(RIGHT(Y2,15))*5+LEFT(RIGHT(Y2,14))*8+LEFT(RIGHT(Y2,13))*4+LEFT(RIGHT(Y2,12))*2+LEFT(RIGHT(Y2,11))*1+LEFT(RIGHT(Y2,...
原创
2021-01-06 15:33:49 ·
452 阅读 ·
0 评论