Excel单元格B4内保存了身份证号码,如果需要提取性别信息

---

问题: Excel单元格B4内保存了身份证号码,如果需要提取性别信息,(身份证倒数第2位,奇数为男,偶数为女),正确的公式是?

A: =IF(MOD(MID(B4,16,17),2)=1,"男","女")

B:=IF(MOD(MID(B4,16,1),2)=1,"男","女")

C:=IF(MOD(MID(B4,17,18),2)=1,"男","女")

D:=IF(MOD(MID(B4,17,1),2)=1,"男","女")