Hi friends,
Here's what I have so far:
If {Field 1} in ['72148','73221']
Then
"MRI"
else if {Field 2} in ['72148','73221']
Then
"MRI"
I want the formula to display "MRI" if {Field 1} does NOT contain one of these ['72148','73221'] but {Field 2} DOES contains one of these ['72148','73221']. Currently, the formula display is blank.
Please help.....thank you!! Rich
If NOT({Field 1} in ['72148','73221'] ) and {Field 2} in ['72148','73221']
Then
"MRI"
Thank you Ian - this was helpful!
I applied your formula, and then I just needed to add:
else if {Field 1} in ['72148','73221']
Then
"MRI"
Final formula being:
If NOT({Field 1} in ['72148','73221'] ) and {Field 2} in ['72148','73221']
Then
"MRI"
else if {Field 1} in ['72148','73221']
Then
"MRI"