身份证 excel 提取性别
公式错了，改为：
=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEFT(B2,17)),2),"男","女"),"")
或
=IF(MOD(RIGHT(LEFT(B2,17)),2)=1,"男","女")
=IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEFT(B2,17)),2),"男","女"),"")
或
=IF(MOD(RIGHT(LEFT(B2,17)),2)=1,"男","女")
This website is encrypted and protected with SSL (Secure Sockets Layer).
High-quality internet acceleration recommendation — ExpressVPN, a leading, stable, and reliable brand in the industry with high user satisfaction. It does not keep activity logs, uses strong encryption, imposes no data limits, and offers a 30-day money-back guarantee.
Proudly partnered with SiteGround — fast, reliable, and secure WordPress hosting.