身份证 excel 提取性别

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

=IF(MOD(RIGHT(LEFT(B2,17)),2)=1,"男","女")