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 ,

 

try 

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

if [FEMALE_AGE_RANGE] = null
then "Male"
else
"Female"
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mussaenda

 

Thanks for this. It worked so the only difference between your query and my query is that extra space between "else" and "if" 😐 ? and how did you find out about this issue? I did not even think in your direction at all. Thanks again

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