OR Statement not working as expected. What am I doing wrong?

[AlexAlberga727]

I have been utilizing the below IF statement - and it works as expected. However, I now need to add an additional parameter to check for Orders that also now start with a "T".

Drop-Ship/Warehouse Order Filter = 
IF( 
        fSales[CustomerID] = "Amazon" && LEFT(fSales[PO],1) <> "U"  ,
            "Warehouse Order",
            "Drop-Ship Order")

When I add in this additional parameter the formula no longer works. Please help. Below is the formula I have created, and have also tried other ways and I feel as if Im not aware of something.

Drop-Ship/Warehouse Order Filter = 
IF( 
        fSales[CustomerID] = "Amazon" && LEFT(fSales[PO],1) <> "U" || fSales[CustomerID] = "Amazon" && LEFT(fSales[PO],1) <> "T" ,
            "Warehouse Order",
            "Drop-Ship Order")

Please let me know if there is a better way of doing so. Maybe SWITCH will work better. I'll start futsing around with SWITCH.

Thanks in advance!

[AlexAlberga727]

@CNENFRNL Thanks for the infomation. However, do you have a solution to the problem I presented, or just throwing out information that im already following.

[CNENFRNL · Accepted solution]

@AlexAlberga727 , I can't catch you with what you described in your first post,

... add an additional parameter to check for Orders that also now start with a "T".

You mean NOT starts with "T" either, right?

You might try to author it this way,

Drop-Ship/Warehouse Order Filter =
IF (
    fSales[CustomerID] = "Amazon"
        && NOT LEFT ( fSales[PO], 1 ) IN { "U", "T" },
    "Warehouse Order",
    "Drop-Ship Order"
)

//if fSales[CustomerID] is "Amazon" and fSales[PO] doesn't start with "U" or "T", then "Warehouse Order", else "Drop-Ship Order"

[AlexAlberga727]

This works for my needs. Thanks a bunch. Interesting way you have coded this one. I have not used IN in that fashion. I'll add this to my quiver.

Thanks!

[AlexAlberga727]

@CNENFRNL It seems as if I am following that guidince. <> before ||.

Is this how you're interpreting the rules too?

[CNENFRNL]

@AlexAlberga727 , yes, <> (comparison operator) is precedent than || (logical operator).

[CNENFRNL]

Hi, @AlexAlberga727 , operators are assigned different precedences; you might want to refer to this table for details and tweak your formula accordingly.