Odd and Even

[xxsalahxx]

Hello

I have a spreadsheet with a lot of data and im trying to calculate from a ten digit number which is in text format, if digit 9 is an odd number this is Male and if its an even number its female, is there any way I can do this?

for example:
if the number in cell A6 is 0210850081 the number 8 would be female.

if the number in cell A6 is 0210850091 the number 9 would be male.


Thanking you in advance for any help you can give

 

[stigcorneer]

=IF(ISODD(NUMBERVALUE(MID(A1,9,1))),"male","female")

 

[SunnyAlv]

like this ?

=IF(ISODD(LEFT(RIGHT(AF821,2),1)),"Male","Female")

 

[saboh12617]

Hello, i do not know if those functions are all avaliable in excel 2007 but this should work

=IF(MOD(VALUE(MID(A6, 8, 1)), 2)=0, "Female", "Male")

 

[xxsalahxx]

=IF(ISODD(NUMBERVALUE(MID(A1,9,1))),"male","female")

Thank you for your quick response, that worked!!