Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Facing issues with the IF statement

Hi All,   Below is the table and the following formula is used in excel. The logic is straightforward in excel. I am trying to find the Gender based on values present in column A and B.  Formula -...
Need Help
  • mussaenda's avatar
    mussaenda
    3 years ago

    Hi Anonymous ,

     

    try 

    if [FEMALE_AGE_RANGE] = [MALE_AGE_RANGE]
then "No Data"
else 

if [FEMALE_AGE_RANGE] = null
then "Male"
else
"Female"
mussaenda's avatar
mussaenda
Community Champion
3 years ago

Hi Anonymous ,

 

Glad it worked. It is still your query. 

The difference is the null that you treated as a string because of ""

 

It should be null and not "null"

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks mate. Clear 🙂