Discussions

Expand all | Collapse all

2 Criteria return a value

  • 1.  2 Criteria return a value

    Posted 10-23-2017 20:12
    So I have my data that I would like to return a specific value based on 2 different fields.

    For example, I have this: 
    If([What's your shipping address?: State/Region]="Alaska","Superman")

    But I need it to be if([What's your shipping address?: State/Region]="Alaska", [bin]="000000", "Superman")

    Any ideas how to accomplish this


  • 2.  RE: 2 Criteria return a value

    Posted 10-23-2017 20:22
    Nevermind... I think I figured it out. SMH 

    if([What's your shipping address?: State/Region]="Alaska" AND [bin]="000000", "Superman")