Skip to main content
Question

Help writing a if statement

  • Oct 4, 2017 1:40 AM UTC
  • 0 replies
  • 70 views

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.  

 
This topic has been closed for replies.

  • Qrew Corporal
  • Oct 4, 2017 2:33 AM UTC
If([Type]="Popcorn", 40, [Area])