Skip to Content

If In Then Else Formula Question

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 20, 2017 at 04:04 PM

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

    Then

    "MRI"

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2017 at 06:21 PM

    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"

    Add comment
    10|10000 characters needed characters exceeded