excel提取表格数字并判断奇偶数性别

=MID(A2,3,1)
=IF(ISODD(B2)=TRUE,"男","女")
放一起就是：=IF(ISODD(MID(A2,3,1))=TRUE,"男","女")