Writing an If statement with multiple OR

[soumya]

How can I write an if then statement which has multiple conditions in it? I tried using || instead of "or" but it didn't work. Is there any way to write this logic? 

For eg: 

if site name = "Yahoo" OR "Google" 

then "X"

Elseif site name = "CNN" OR "CBS"

then "Y"

ELSEIF "Z" endif 

[DylanB · Accepted solution]

if [site name] = "Yahoo" OR [site name] = "Google" then "X"
ELSEIF [site name] = "CNN" OR [site name] = "CBS" then "Y"
ELSE "Z" 
ENDIF

Think of the "OR" as an operator on two logical statements, so the code before and after should each evaluate to TRUE or FALSE

[JohnJPS]

I'm not at my computer, but you can certainly do something like

IF [siteName] == "Google" OR [siteName] == "Yahoo" THEN

... you could also check for IN... e.g.

IF [siteName] IN ("Google","Yahoo") THEN

[jdunkerley79]

Worth considering the SWITCH statement as well:

SWITCH([site name],"Z",
    ."Yahoo","X"
    ,"Google","X",
    ,"CNN","Y",
    ,"CBS","Y"
)

[jdunkerley79 · Accepted solution]

Too many commas in my formula. Fixed version:

SWITCH([site name],"Z"
    ,"Yahoo","X"
    ,"Google","X"
    ,"CNN","Y"
    ,"CBS","Y"
)

(Shouldn't have written it on a mobile!)

[ignas]

In this case and in a lot of other cases Switch formula is better and it is shorter.

[ejohnson]

I want to do something similar to this, but use the contain formula as the field may have other information as well. So I tried the following, but it does not bring out the results I'm expecting...

if contains("Yahoo",[site name]) OR contains("Google",[site name]) then "X"
ELSE "Z" 
ENDIF

[nsessa]

I am having the same issue as well. Does anyone have a resolution? 

[JohnJPS]

@ejohnson , @nsessa ,

I think the issue in your example is just the order of the field vs what is contained in the field: list the field name first:

if contains([site name],"Yahoo") OR contains([site name],"Google") then "X"
ELSE "Z" 
ENDIF

Hope that helps!

John