2 Criteria return a value

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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
Photo of Tony

Tony

  • 172 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Tony

Tony

  • 172 Points 100 badge 2x thumb
Nevermind... I think I figured it out. SMH 

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