excel公式计算15-18身份证
excel公式计算15-18身份证
=IF(LEN(A2)=15,REPLACE(A2,7,,19)&MID("10X98765432",MOD(SUMPRODUCT(MID(REPLACE(A2,7,,19),ROW($1:$17),1)*2^(18-ROW($1:$17))),11)+1,1),A2)
excel公式计算18-15身份证
=IF(LEN(C2)=0,"",IF(LEN(C2)=15,CONCATENATE("19",MID(C2,7,2),".",MID(C2,9,2)),IF(LEN(C2)=18,CONCATENATE(MID(C2,1,6),"",MID(C2,9,9)),"身份证错")))
excel公式计算15-18身份证
=IF(LEN(A2)=15,REPLACE(A2,7,,19)&MID("10X98765432",MOD(SUMPRODUCT(MID(REPLACE(A2,7,,19),ROW($1:$17),1)*2^(18-ROW($1:$17))),11)+1,1),A2)
excel公式计算18-15身份证
=IF(LEN(C2)=0,"",IF(LEN(C2)=15,CONCATENATE("19",MID(C2,7,2),".",MID(C2,9,2)),IF(LEN(C2)=18,CONCATENATE(MID(C2,1,6),"",MID(C2,9,9)),"身份证错")))