关于计算统一社会信用代码校验码的公式(Excel版本)

=MID("123456789ABCDEFGHJKLMNPQRTUWXY0",31-MOD(SUM((FIND(MID(B2,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17},1),"0123456789ABCDEFGHJKLMNPQRTUWXY")-1)*{1,3,9,27,19,26,16,17,20,29,25,13,8,24,10,30,28}),31),1)&""

posted on 2024-09-24 10:47  康仔☆  阅读(116)  评论(0编辑  收藏  举报

导航