Help writing a if statement

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have Field one [Type] (text field) and Field 2 [Area] (Related Table numeric: 10,20,30) I have made an additional field [field 3] that I want to show Field 2 unless Field one = Popcorn then Field three to show 40.  

 
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
If([Type]="Popcorn", 40, [Area])