身份证 excel 提取性别 Get link Facebook X 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 X Pinterest Email Other Apps