不同公式实现通过身份证号码判断性别
公式如下:
=IF(MOD(MID(A2,17,1),2)=0,”女”,”男”)
=IF(ISODD(MID(A3,17,1)),”男”,”女”)
=IF(ISEVEN(MID(A4,17,1)),”女”,”男”)
=CHOOSE(MOD(MID(A5,17,1),2)+1,”女”,”男”)
=IF(MOD(MID(A6,17,1),2)=0,”女”,”男”)
=IF(ISODD(MID(A7,17,1)),”男”,”女”)
=IF(ISEVEN(MID(A8,17,1)),”女”,”男”)
=CHOOSE(MOD(MID(A9,17,1),2)+1,”女”,”男”)
=VLOOKUP(MOD(MID(A10,17,1),2),{1,”男”;0,”女”},2,FALSE)
=VLOOKUP(ISODD(MID(A11,17,1)),{TRUE,”男”;FALSE,”女”},2,FALSE)
=VLOOKUP(M