Forum Discussion
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 colu...
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.
truptis
Community Champion
Community ChampionHi 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.