=IF(MOD(MID(C2:C56,17,1),2),男,女)