Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Tagging a row by odd / even number input

Topic Labels: Formulas
Solved
Jump to Solution
898 5
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Examples:

XXXXXX-XX-5557 = Male
XXXXXX-XX-5556 = Female.

1 Solution

Accepted Solutions

Hi Santhanasamy, You can achieve this by comparing the last digit against a Switch() statement, like this:

SWITCH( RIGHT(ID,1), 
"1","Male","2","Female", 
"3","Male","4","Female", 
"5","Male","6","Female", 
"7","Male","8","Female", 
"9","Male","0","Female" 
         )

See Solution in Thread

5 Replies 5

Hi Santhanasamy, You can achieve this by comparing the last digit against a Switch() statement, like this:

SWITCH( RIGHT(ID,1), 
"1","Male","2","Female", 
"3","Male","4","Female", 
"5","Male","6","Female", 
"7","Male","8","Female", 
"9","Male","0","Female" 
         )

Yes, that would work fine!

Another way to do this would be to use the MOD() function like this:

IF(MOD(RIGHT(ID,1),2)=0,"Female","Male")

And if the ID field is a number field, you’ll need to convert it to text first in order to make it work with the RIGHT() function like this:

IF(MOD(RIGHT(ID&"",1),2)=0,"Female","Male")

Hi, thank you this worked!

Hi, I tried the 1st formula but there was a problem, if the ID cell was blank, it would also tag the record.

Then you would need to wrap that formula in another IF statement to check if the ID cell is blank:

If ID is a text field:
IF(ID=BLANK(),"",IF(MOD(RIGHT(ID,1),2)=0,"Female","Male"))

If ID is a number field:
IF(ID=BLANK(),"",IF(MOD(RIGHT(ID&"",1),2)=0,"Female","Male"))