Help with =mid(b6,5,1) = f or m or unused

[Jack Sseruwo]

Hello Excellers...

I have attached a picture of a fx=MID formula whose result I want to now determine as male or female or unused.
The results in the column marked Sex should indicate that 1=M (male), 2=F (female) or 0 = (Unused).
Can anyone please assist me? I am working in a very secluded place and all I have is this online resource to get this done urgently.

Appreciated.

 

[Jack Sseruwo]

Hello Excellers...

I have attached a picture of a fx=MID formula whose result I want to now determine as male or female or unused.
The results in the column marked Sex should indicate that 1=M (male), 2=F (female) or 0 = (Unused).
Can anyone please assist me? I am working in a very secluded place and all I have is this online resource to get this done urgently.

Appreciated.

Oh, if there any other alternative formulae to go about what I am trying to achieve, please share them as well as long as they can achieve the same result.

 

[bosco_yip]

In E6, copied down :

=INDEX({"Unused","Male","Female"},MID(B6,5,1)+1)

Regards

 

[Jack Sseruwo]

In E6, copied down :

=INDEX({"Unused","Male","Female"},MID(B6,5,1)+1)

Regards

=INDEX({"Unused","Male","Female"},MID(B6,5,1)+1)

Thank you so much Bosco it has worked perfectly

 

[Peter_SSs]

Another option
=CHOOSE(MID(B6,5,1)+1,"Unused","Male","Female")

 

[Jack Sseruwo]

Another option
=CHOOSE(MID(B6,5,1)+1,"Unused","Male","Female")

Thanks

 

[Peter_SSs]

You're welcome. Thanks for following up on the responses.