关于计算统一社会信用代码校验码的公式(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)&""
道生一,一生二,二生三,三生万物。