LamarAt
Chemical
- Apr 20, 2006
- 4
I am trying to enter a formula to calculate a text field based on the Resource Name. What I want to do is test the resource name to see if it CONTAINS a certain string. The only options I see are =, <>, <, > . Below is an example of what I am using but it is not exact.
IIf([Resource Names]="ANLZ-1" Or [Resource Names]="E&I-1","GREG","JIM")
What I need is more like:
IIf([Resource Names]CONTAINS "ANLZ" Or [Resource Names]CONTAINS "E&I","GREG","JIM")
Any help would be appreciated!
IIf([Resource Names]="ANLZ-1" Or [Resource Names]="E&I-1","GREG","JIM")
What I need is more like:
IIf([Resource Names]CONTAINS "ANLZ" Or [Resource Names]CONTAINS "E&I","GREG","JIM")
Any help would be appreciated!