Forum Discussion

damonkimble's avatar
damonkimble
Frequent Visitor
5 years ago
Solved

Nested IF Statement with logical or condition

Hi All! I created nested if statements that contain OR conditions. Example: IF a = 1 or b = 1, then "Pass" IF "a=2 or b=2", then "Fail", IF blank(), then "TBD". The problem is my result has "Pass" o...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    Note that the logical statement "a <> 1 || a <>2" is always true since if a <> 1 then the first case hold and, otherwise, if a = 1, then a <> 2 and the second case holds. This is why you never get to the "TBD" condition.

     

    The negation of "a = 1 || a = 2" is not "a <> 1 || a <> 2" but rather "NOT ( a =1 || a = 2 )" = "a <> 1 && a <> 2".

     

    I'd recommend rewriting your logic more compactly like this:

    FTC_Fail_Pass =
IF (
    ISBLANK ( Booking[brs_followupreason (groups)] ),
    "TBD",
    IF (
        Booking[brs_followupreason (groups)]
            IN {
            "Customers did not show up for meet",
            "Branch staff turned me away",
            "Site not ready",
            "Vendor did not show up for meet"
        },
        "Fail",
        "Pass"
    )
)
AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

Note that the logical statement "a <> 1 || a <>2" is always true since if a <> 1 then the first case hold and, otherwise, if a = 1, then a <> 2 and the second case holds. This is why you never get to the "TBD" condition.

 

The negation of "a = 1 || a = 2" is not "a <> 1 || a <> 2" but rather "NOT ( a =1 || a = 2 )" = "a <> 1 && a <> 2".

 

I'd recommend rewriting your logic more compactly like this:

FTC_Fail_Pass =
IF (
    ISBLANK ( Booking[brs_followupreason (groups)] ),
    "TBD",
    IF (
        Booking[brs_followupreason (groups)]
            IN {
            "Customers did not show up for meet",
            "Branch staff turned me away",
            "Site not ready",
            "Vendor did not show up for meet"
        },
        "Fail",
        "Pass"
    )
)