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
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