Hi, I have a base where we key in the ID numbers of each person in a column - Males have odd numbers and females have even numbers.
Would like to create a column that automatically tags them as either Male or female based on this data but I cant seem to figure our what formula to use. Could someone help me? It would be of great help.
XXXXXX-XX-5557 = Male
XXXXXX-XX-5556 = Female.