Multiple IF Criteria Logic

[czjames87]

Good afternoon,

I am trying to create some logic that includes 4 different criteria. However, while it doesn't error out, the logic only reads the first two criteria and ignores the last two. Essentially i want the logic to read as below

If (RSD Reason Group) says "carrier related" or Ryder Related" , "Invalid Reason Code" and " Missing Valid Reason Code" than "NO" else "YES" endif. Any help would be greatly appreciated. Below is what i am currently using.

IIF ([RSD_Reason Group] IN ("Carrier" , "Ryder","Invalid Reason Code" , "Missing Valid Reason Code") ,"NO", "YES")

[ImadZidan · Accepted solution]

Hello @czjames87 ,

I have just tested your logic and it looks good. I am getting NO for all values.

Where is it failing. Check the values that you do not include extra character. May add a cleansing tool before the check or even a trim around the field which I did.

Check it and let us know.

Hope it helps.

[czjames87]

you were correct. I was missing some of that data in one of the fields I was using. Once I updated it worked as expected. Thank you for your help.