Skip to main content
Question

2 Criteria return a value

  • October 24, 2017
  • 0 replies
  • 20 views
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
      This topic has been closed for replies.

      • TonyTony1
      • Author
      • Registered
      • October 24, 2017
      Nevermind... I think I figured it out. SMH 

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