Multiple Conditions in Formula

Hi,

I am trying to use multiple "IF" formulas on a data set but it is only picking up the last formula (ICCT4 - as seen in results window)

SOS!

Workflow

Accepted answers

JoeS

You can also use ELSEIF.

So you could put all 4 of those into one:

IF [Zeus] = "265" THEN "ICCT1"
ELSEIF [Zeus] = "266" THEN "ICCT2"
ELSEIF [Zeus] = "290" THEN "ICCT3"
ELSEIF [Zeus] = "190" THEN "ICCT4"
ELSE "pending"
ENDIF

All comments

WilliamR

You can use a switch formula: Switch(Value,Default,Case1,Result1,...,CaseN,ResultN) instead of multiple if.

https://help.alteryx.com/2018.2/Reference/Functions.htm

emiafshar

@WilliamR wrote:
You can use a switch formula: Switch(Value,Default,Case1,Result1,...,CaseN,ResultN) instead of multiple if.
https://help.alteryx.com/2018.2/Reference/Functions.htm

Hi William,

Thanks for getting back to me.

How would the Switch formula work as I can't seem to figure out what the Default, CaseN fields would include?

Thanks!

JoeS

You can also use ELSEIF.

So you could put all 4 of those into one:

IF [Zeus] = "265" THEN "ICCT1"
ELSEIF [Zeus] = "266" THEN "ICCT2"
ELSEIF [Zeus] = "290" THEN "ICCT3"
ELSEIF [Zeus] = "190" THEN "ICCT4"
ELSE "pending"
ENDIF

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703