![](https://lstatic.shangxueba.com/jiandati/pc/images/pc_jdt_tittleico.png)
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,”男”,”女”)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_q_ckda.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_panel_vip.png)
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_q_wyda.png)
- · 有3位网友选择 B,占比37.5%
- · 有3位网友选择 A,占比37.5%
- · 有2位网友选择 C,占比25%