Thanks it works

"Ms-Exl-Learner" wrote:

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?