Prev: Excel hyperlink within workbook and SharePoint drafts
Next: Are there shortcut keys in Excel for Cell Alignment?
From: Mags on 20 May 2010 06:07
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,VALUE(MID(TRIM(A1),8,1))<=4),"Female",IF(AND(VALUE(MID(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?
First  |  Prev  | 
Pages: 1 2
Prev: Excel hyperlink within workbook and SharePoint drafts
Next: Are there shortcut keys in Excel for Cell Alignment?