How to use excel to identify 18 issue of gender identity?
For example, gender identity, in the A1 to C1 reflect. = IF (LEN (I4) = 18, IF (ISBLANK (I4 ),””, IF (MID (I4, 15,3) / 2 = INT (MID (I4, 15,3) / 2), “M” and “M”)), IF (ISBLANK (I4) , “”, IF (MID (I4, 13,3) / 2 = INT (MID …