=IF(MOD(MID(D2,17,1),2)=1,男,女)