Quote:
Originally Posted by Mags
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?
|
assuming there are no spaces in the id number and id number exit in B1 cell,
copy this formulae in C1
=IF(N(RIGHT(LEFT(B1,7),1))<6,"Female","Male")
all the best