Excel身份证验证，身份证校验公式
摘要：
=IF(LEN(Q4)=0,"空",IF(LEN(Q4)=15,"老号",IF(LEN(Q4)<>18,"位数不对",IF(CHOOSE(MOD(SUM(MID(Q4,1,1)*7+MID(Q4,2,1)*9+MID(Q4,3,1)*10+MID(Q4,4,1)*5+MID(Q4,5,1)*8+MI 阅读全文
posted @ 2018-05-10 10:40 chaoliu1 阅读(10880) 评论(0) 推荐(0)
浙公网安备 33010602011771号