If In Then Else Formula Question

[former_member406941]

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

[Former Member · Accepted solution]

If NOT({Field 1} in ['72148','73221'] ) and {Field 2} in ['72148','73221']

Then

"MRI"

[former_member406941]

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"