我用这个也管用，不知道什么原理=IF(LOOKUP((LEFT(c1050,1)*7+MID(c1050,2,1)*9+MID(c1050,3,1)*10+MID(c1050,4,1)*5+MID(c1050,5,1)*8+MID(c1050,6,1)*4+MID(c1050,7,1)*2+MID(c1050,8,1)+MID(c1050,9,1)*6+MID(c1050,10,1)*3+MID(c1050,11,1)*7+MID(c1050,12,1)*9+MID(c1050,13,1)*10+MID(c1050,14,1)*5+MID(c1050,15,1)*8+MID(c1050,16,1)*4+MID(c1050,17,1)*2)-ROUNDDOWN((LEFT(c1050,1)*7+MID(c1050,2,1)*9+MID(c1050,3,1)*10+MID(c1050,4,1)*5+MID(c1050,5,1)*8+MID(c1050,6,1)*4+MID(c1050,7,1)*2+MID(c1050,8,1)+MID(c1050,9,1)*6+MID(c1050,10,1)*3+MID(c1050,11,1)*7+MID(c1050,12,1)*9+MID(c1050,13,1)*10+MID(c1050,14,1)*5+MID(c1050,15,1)*8+MID(c1050,16,1)*4+MID(c1050,17,1)*2)/11,0)*11,{0,1,2,3,4,5,6,7,8,9,10},{"1","0","x","9","8","7","6","5","4","3","2"})=RIGHT(c1050,1),"Right","Wrong")