600000000000000000一个银行卡号是19位,前面18位是有简单规律的,最后一位是校验位,通过luhn算法得到。规则为:1、从卡号最后一位数字开始,偶数位乘以2,如果乘以2的结果是两位数,将两个位上数字相加保存。 2、然后与奇数位数字相加,得到总和。 3、如果银行卡号码是合法的,总和可以被10整除。分步偶数和=(0&MID(MID(B2,2,1)*2,1,1))+(0&MID(MID(B2,2,1)*2,2,1))+(0&MID(MID(B2,4,1)*2,1,1))+(0奇数和=MID(B2,1,1)+MID(B2,3,1)+MID(B2,5,1)+MID(B2,7,1)+MID(B2,9,1)+MID(B2,11,1)+MID(B2,13,最终函数=B2&IF(MOD(MID(B2,1,1)+MID(B2,3,1)+MID(B2,5,1)+MID(B2,7,1)+MID(B2,9,1)+MID(B2,11,1示例6000000000000000006000000000000000004法得到。两个位上数字相加保存。 D(MID(B2,4,1)*2,1,1))+(0&MID(MID(B2,4,1)*2,2,1))+(0&MID(MID(B2,6,1)*2,1,1))+(0&MID(MID(B2,6,1)*2,2,1+MID(B2,11,1)+MID(B2,13,1)+MID(B2,15,1)+MID(B2,17,1)+MID(B2,9,1)+MID(B2,11,1)+MID(B2,13,1)+MID(B2,15,1)+MID(B2,17,1)+(0&MID(MID(B2,2,1)*2,1,1))+(0&MID(M2,6,1)*2,2,1))+(0&MID(MID(B2,8,1)*2,1,1))+(0&MID(MID(B2,8,1)*2,2,1))+(0&MID(MID(B2,10,1)*2,1,1))+(0&MID(MID(B2,2,1)*2,2,1))+(0&MID(MID(B2,4,1)*2,1,1))+(0&MID(MID(B2,4,1)*2,2,1))+(0&MID(M2,10,1)*2,1,1))+(0&MID(MID(B2,10,1)*2,2,1))+(0&MID(MID(B2,12,1)*2,1,1))+(0&MID(MID(B2,1)*2,2,1))+(0&MID(MID(B2,6,1)*2,1,1))+(0&MID(MID(B2,6,1)*2,2,1))+(0&MID(MID(B2,8,1)*2,1,1))+(0&MID(MD(B2,12,1)*2,2,1))+(0&MID(MID(B2,14,1)*2,1,1))+(0&MID(MID(B2,14,1)*2,2,1))+(0&MID(MID(1)*2,1,1))+(0&MID(MID(B2,8,1)*2,2,1))+(0&MID(MID(B2,10,1)*2,1,1))+(0&MID(MID(B2,10,1)*2,2,1))+(0&MID(MID(B2,16,1)*2,1,1))+(0&MID(MID(B2,16,1)*2,2,1))+(0&MID(MID(B2,18,1)*2,1,1))+(0&MID(MI0,1)*2,2,1))+(0&MID(MID(B2,12,1)*2,1,1))+(0&MID(MID(B2,12,1)*2,2,1))+(0&MID(MID(B2,14,1)*2,1,1))+(0&ID(MID(B2,18,1)*2,2,1))2,14,1)*2,1,1))+(0&MID(MID(B2,14,1)*2,2,1))+(0&MID(MID(B2,16,1)*2,1,1))+(0&MID(MID(B2,16,1)*2,2,1))+(1)*2,2,1))+(0&MID(MID(B2,18,1)*2,1,1))+(0&MID(MID(B2,18,1)*2,2,1)),10)=0,0,10-MOD(MID((MID(B2,1,1)+MID(B2,3,1)+MID(B2,5,1)+MID(B2,7,1)+MID(B2,9,1)+MID(B2,11,1)+MID(B2,13,1)13,1)+MID(B2,15,1)+MID(B2,17,1)+(0&MID(MID(B2,2,1)*2,1,1))+(0&MID(MID(B2,2,1)*2,2,1))+,1))+(0&MID(MID(B2,4,1)*2,1,1))+(0&MID(MID(B2,4,1)*2,2,1))+(0&MID(MID(B2,6,1)*2,1,1))+,1))+(0&MID(MID(B2,6,1)*2,2,1))+(0&MID(MID(B2,8,1)*2,1,1))+(0&MID(MID(B2,8,1)*2,2,1))+,1))+(0&MID(MID(B2,10,1)*2,1,1))+(0&MID(MID(B2,10,1)*2,2,1))+(0