如题所述
验证公式:
=OR(LEN(A1)=15,IF(LEN(A1)=18,MID("10X98765432",MOD(SUM(MID(A1,ROW(INDIRECT("1:17")),1)*2^(18-ROW(INDIRECT("1:17")))),11)+1,1)=RIGHT(A1)))
如图所示: