Excel教程_利用IF公式快速判断身份证号码是否正确

=IF(RIGHT(C3,1)=LOOKUP(MOD(MID(C3,1,1)*7+MID(C3,2,1)*9+MID(C3,3,1)*10+MID(C3,4,1)*5+MID(C3,5,1)*8+MID(C3,6,1)*4+MID(C3,7,1)*2+MID(C3,8,1)*1+MID(C3,9,1)*6+MID(C3,10,1)*3+MID(C3,11,1)*7+MID(C3,12,1)*9+MID(C3,13,1)*10+MID(C3,14,1)*5+MID(C3,15,1)*8+MID(C3,16,1)*4+MID(C3,17,1)*2,11),{0;1;2;3;4;5;6;7;8;9;10},{“1″;”0″;”X”;”9″;”8″;”7″;”6″;”5″;”4″;”3″;”2″}),”真”,”假”)