<![CDATA[菜根2 2018-2028 - 数据处理]]> http://www.niaochao2008.com/20180311/ zh-cn PBlog2 v2.4 菜根2 2018-2028 http://www.niaochao2008.com/20180311/images/logos.gif http://www.niaochao2008.com/20180311/ 菜根2 2018-2028 http://www.niaochao2008.com/20180311/article.asp?id=38 <![CDATA[idexcel校验计算公式]]> shopsha2002@126.com(admin) Mon,03 Dec 2018 09:52:52 +0800 http://www.niaochao2008.com/20180311/default.asp?id=38  =CHOOSE(MOD(SUM((MID(A2,1,1)+MID(A2,11,1))*7+(MID(A2,2,1)+MID(A2,12,1))*9+(MID(A2,3,1)+MID(A2,13,1))*10+(MID(A2,4,1)+MID(A2,14,1))*5+(MID(A2,5,1)+MID(A2,15,1))*8+(MID(A2,6,1)+MID(A2,16,1))*4+(MID(A2,7,1)+MID(A2,17,1))*2+MID(A2,8,1)+

MID(A2,9,1)*6+MID(A2,10,1)*3),11)+1,1,0,"X",9,8,7,6,5,4,3,2)

]]>