打开App
360P
Excel小技巧之根据身份证号码求性别
Excel小技巧之根据身份证号码求性别 =IF(MOD(MID(B2,17,1),2)=1,"男","女")
Excel函数11/14
App01:00
App00:43
App01:02
App01:18
App00:22
App00:41
App00:30
App00:55
App00:18
App01:00
App01:34
App00:54
App00:32
App00:35Excel小技巧之根据身份证号码求性别 =IF(MOD(MID(B2,17,1),2)=1,"男","女")
App01:00App00:43App01:02App01:18App00:22App00:41App00:30App00:55App00:18App01:00App01:34App00:54App00:32App00:35
