公式如下:
=IF(LOOKUP((LEFT(A1,1)*7+MID(A1;
3,1)*10+MID(A1;
4,1)*5+MID(A1;
6,1)*4+MID(A1;
7,1)*2+MID(A1,8,1)+MID(A1,9,1)*6+MID(A1,10,1)*3+MID(A1,11,1)*7+MID(A1,12,1)*9+MID(A1,13,1)*10+MID(A1,14,1)*5+MID(A1,15,1)*8+MID(A1,16,1)*4+MID(A1,17,1)*2)-ROUNDDOWN((LEFT(A1,1)*7+MID(A1;
2,1)*9+MID(A1;