ID number to Gender
Assume that you are having the value in A1 cell
A1 Cell
751105 0 931087
Copy and paste the below formula in B1 cell.
=IF(A1="","",IF(AND(VALUE(MID(TRIM(A1),8,1))=0,VA LUE(MID(TRIM(A1),8,1))<=4),"Female",IF(AND(VALUE(M ID(TRIM(A1),8,1))=5,VALUE(MID(TRIM(A1),8,1))<=9), "Male","")))
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"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?
|