第1个回答 2011-08-08
假设身份证号码在A1单元格,在B1中自动输出性别,则在B1中输入公式(自动判断15位和18位身份证)
=IF(LEN(A1)=15,IF(MOD(RIGHT(A1,1),2)=0,"女","男"),IF(MOD(MID(A1,17,1),2)=0,"女","男"))
或者
=IF(MOD(IF(LEN(A1)=15,RIGHT(A1,1),MID(A1,17,1)),2)=0,"女","男")
第2个回答 2011-08-08
设A1单元格有身份证号码,则
=IF(LEN(A1)=18,IF(MOD(MID(A1,17,1),2)=1,"男","女"),IF(LEN(A1)=15,IF(MOD(RIGHT(A1,1),2)=1,"男","女"),"身份证长度不合法"))
第3个回答 2011-08-08
=IF(LEN(B2)=15,IF(MOD(VALUE(RIGHT(B2,3)),2)=0,"男","女"),IF(LEN(B2)=18,IF(MOD(VALUE(MID(B2,15,1)),2)=0,"男","女"),"身份证错")),本回答被网友采纳
第4个回答 2011-08-08
设A1为身份证号码
=if(mod(mid(A1,17,1),2)=0,"女","男")