输入公式:

=IF(RIGHT(B6)=MID("10X98765432",MOD(SUM(MID(B6,ROW(INDIRECT("1:17")),1)*2^(18-ROW(INDIRECT("1:17")))),11)+1,1),"真","假")

然后切记一定按ctrl+shift+回车


发表评论