Skip to main content
Question

Help writing a if statement

  • October 4, 2017
  • 0 replies
  • 64 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.

  • Registered
  • October 4, 2017
If([Type]="Popcorn", 40, [Area])