Forum Discussion

TonyTony1's avatar
TonyTony1
Qrew Cadet
8 years ago

2 Criteria return a value

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
  • TonyTony1's avatar
    TonyTony1
    Qrew Cadet
    8 years ago
    Nevermind... I think I figured it out. SMH 

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