=RIGHT(10-RIGHT((MID(B2,12,1)+MID(B2,10,1)+MID(B2,8,1)+MID(B2,6,1)+MID(B2,4,1)+MID(B2,2,1))*3+(MID(B2,11,1)+MID(B2,9,1)+MID(B2,7,1)+MID(B2,5,1)+MID(B2,3,1)+MID(B2,1,1)),1),1)
转载于:https://blog.51cto.com/mlibra/215392
转载于:https://blog.51cto.com/mlibra/215392