=IF(B3="","",(IF(MID("10X98765432",MOD(SUMPRODUCT(MID(B3,ROW(INDIRECT("1:17")),1)*2^(18-ROW(INDIRECT("1:17")))),11)+1,1)=MID(B3,18,18),"正确","错误")))

标签 excel