身份证 excel 提取性别

公式错了，改为：
=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEFT(B2,17)),2),"男","女"),"")
或
=IF(MOD(RIGHT(LEFT(B2,17)),2)=1,"男","女")