Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need a help with & formula

Hi Experts

I have added a column in my access db table to compute the below result.

 

I would like to get the result as "XYZ" if the XYZ column has "Yes" in it. Else if "ABC" if the ABC column has "Yes" in it or the result should be blank. My first priority result is XYZ not ABC.

Please can someone help me with the formula to achieve this.

Thanks
Mahad

Need Help
  • truptis's avatar
    truptis
    4 years ago

    Hi Anonymous ,

    Try using this:
    Result = IF([ABC]="Yes", "ABC", IF([XYZ]="Yes","XYZ",""))

    Anonymous -> Please hit the thumbs up & mark it as a solution if this helps you. Thanks.

1 Reply

  • truptis's avatar
    truptis
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous ,

    Try using this:
    Result = IF([ABC]="Yes", "ABC", IF([XYZ]="Yes","XYZ",""))

    Anonymous -> Please hit the thumbs up & mark it as a solution if this helps you. Thanks.