2 Criteria return a value

  • 0
  • 1
  • Question
  • Updated 2 years 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

  • 194 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Tony

Tony

  • 194 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")