IF OR STATEMENT

Question

I am trying to write a simple IF OR statement in Alteryx but I am unsure how. This is the statement as it stands right now:

IIF ([Final Classification]='Bad Debt', "Bad Debt",[Owner Step 4])

I want to add an OR statement to this however that would be IF Final Classification is Bad Debt OR Billback then Bad Debt, Billback, if it doesn't meet the condition then the result is Owner Step 4.

How can I do this?

binu_acs · Answer

@KRSANCHEZ using IN operator instead  of OR operator is another option

IF [Final Classification] IN ('Bad Debt','Billback')
THEN 'Bad Debt, Billback'
ELSE [Owner Step 4] 
ENDIF

atcodedog05 · Answer

Hi @KRSANCHEZ

One way to do it

IIF ([Final Classification]='Bad Debt', "Bad Debt",
IIF ([Final Classification]='Billback', "Billback",[Owner Step 4]))

Or

IF [Final Classification]='Bad Debt' THEN 'Bad Debt'
ELSEIF [Final Classification]='Billback' THEN 'Billback' 
ELSE [Owner Step 4] ENDIF

Or if you want a single check statement

IF [Final Classification]='Bad Debt' OR
[Final Classification]='Billback' 
THEN 'Bad Debt, Billback'
ELSE [Owner Step 4] ENDIF

Hope this is what you are looking for.