# 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 (I4, 13,3) / 2), “M” and “M “)))

this formula applies to At 15 or 18 cards, identity card number for the I4, attention is the text.15-digit ID card is the last woman is even number, the number of single men is the identity of the median

18 Permit penultimate position (No.17) is double the number that woman, is the odd man Oo, the landlord did not encounter such a problem? Do not know what is meant.= IF (MOD (VALUE (RIGHT (A1, 3 )), 2), “M” and “F”)

which 15 and 18 card will do.

Would like to help you! = IF (A1 =””,””, IF (MOD (MID (A1, IF (LEN (A1) = 15,15,17), 1), 2), “M” and “F”)) This formula 15 18 General

= IF (MOD (RIGHT (MID (A1, 7,11), 3), 2), “M” and “F”) = IF (MOD (MID (A1, 15,3 ), 2), “M” and “F”) = IF (MOD (MID (A1, 15,3), 2), “M” and “F”)

men and women may be the location of the anti – You can try to look

## Leave a Reply

You must be logged in to post a comment.