这里写自定义目录标题 身份证号码校验电话号码校验 身份证号码校验 =IF(D2="","",(IF(MID("10X98765432",MOD(SUMPRODUCT(MID(D2,ROW(INDIRECT("1:17")),1)*2^(18-ROW(INDIRECT("1:17")))),11)+1,1)=MID(D2,18,18),"正确","错误"))) 电话号码校验 =AND(LEFT(C2)="1",OR(MID(C2,2,1)="3",MID(C2,2,1)="5",MID(C2,2,1)="8"),LEN(C2)=11)