身份证 excel 提取性别 Get link Facebook Twitter Pinterest Email Other Apps 公式错了,改为: =IF(OR(LEN(B2)={15,18}),IF(MOD(RIGHT(LEFT(B2,17)),2),"男","女"),"") 或 =IF(MOD(RIGHT(LEFT(B2,17)),2)=1,"男","女") Get link Facebook Twitter Pinterest Email Other Apps