IF AND OR Formula

[Klachner]

I need help with the following formula

if [countdistinct_entity] = 1 AND IF Contains([receiving_entity],"X") OR contains([receiving_entity],"Y") THEN "X" ELSE "Keep" ENDIF

[cjaneczko]

if [countdistinct_entity] = 1 AND REGEX_Match([receiving_entity],".*(X|Y).*") THEN "X" ELSE "Keep" ENDIF

[binu_acs]

@Klachner 

IF [countdistinct_entity] = 1 
AND  
(Contains([receiving_entity],"X") OR contains([receiving_entity],"Y"))
 THEN "X" 
ELSE "Keep"
ENDIF

[Klachner]

The formula doesn't seem to be working consistently. It is pulling some [Countdistinct_receiving_entity] = 3 with the receiving entity being either x or y and giving it a "X"

[cjaneczko · Accepted solution]

It shouldnt be.

[Klachner]

Is that a "/" or a straight up and down line?

[Klachner]

Here is a screenshot

[cjaneczko · Accepted solution]

Straight up and down. Not sure what it italicizes it in the formula box. Its the key above the Enter key on the keyboard. 

[Klachner]

That was my issue thank you. Going forward where do I find the straight up and down line on my keyboard?

[cjaneczko]

I had edited my comment after submitting it, but its the key above your Enter Key. Hold Shift on the \ key.