Hi let’s say I have a pool of data and some of the genders are unspecified in an excel sheet. What excel formulas should I use to find the gender using the IC. Something like “if last digit of IC is odd numbers, Gender = Male” and so on. Tenks guys

Use the =ISODD(A1) function, then =IF(A2=TRUE,"Male","Female")

This post has been edited by Flame Haze: Dec 27 2018, 11:38 AM

get last digit =MID(A1, LAST NUMBER, 1)

if statement =IF(MOD(A1,2)=0,"FEMALE","MALE")

This post has been edited by GPKGB: Dec 27 2018, 11:39 AM

my way, not very efficient way

1.Copy the list into new column
2.Text to column only the last digit into new cell
3. Use if function in the single digit cell, if odd = male, even = female

ic even=female, odd=male is a myth

most of the time it works, so

guna je la

the best way is to use INDEX MATCH.

simpler formula

=IF(ISODD(RIGHT(A1,4)),"MALE","FEMALE")

The RIGHT is to capture last 4 digit only.

INDEX MATCH is best way comparing to VLOOKUP
but this is not what he asking for.

I learnt something today

Excel is god program for audit work

Thank you for recommending a rocket launcher when all he needed was a revolver.

=IF(ISEVEN(RIGHT(A2,1)),"FEMALE","MALE")

=IF(ISODD(RIGHT(target cell,1))="True","Male","Female")

You're welcome

helping is never my intention.

this will pop-up:

+1

use this TS.

If I, I would use regular expression lagi senang

Redundant, IF function itself already checks for TRUE/FALSE.

Can ayam ask u if ayam got excel question in future?