Writing an If statement with multiple OR

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

Predictive Analysis

Accepted answers

DylanB

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

jdunkerley79

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!)

All comments

DylanB

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"
)

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703