ID number to Gender
Hi Jacob,
May i know what is the purpose of putting -- in front of MID and what does
it mean? My formula is quite similar to yours
=IF((MID(A1,7,1)<="4"),"Female","Male") but i need to put "" at the number 4,
though I do not know why I need to do so.
"Jacob Skaria" wrote:
Try
=IF(--MID(A1,7,1)<5,"Female","Male")
or to handle errors & blank entries
=IF(AND(N(A1),LEN(A1)6),IF(--MID(A1,7,1)<5,"Female","Male"),"")
--
Jacob (MVP - Excel)
"Mags" wrote:
I want to see if the employee is a male or female from the ID number?
ID number - 751105 0 931087
The SEVENTH number will tell you if the employee is a male or female
0-4 = Female
5-9 = Male
What formule can I use?
|