IF Logic with multiple conditions

[Glenlim]

How do I convert excel formula: 

=IF(T-1 File="No","Investigate",IF(Portfolio Traded="No","No Investigation",IF(Security Traded="No","No Investigation","Investigate")))

Into Alteryx? 

[Peachyco · Accepted solution]

You can use IF-ELSEIF-ELSE in the Formula Tool, like so:

IF [T1 File] = "No" THEN "Investigate"

ELSEIF [Portfolio Traded] = "No" THEN "No Investigation"

ELSEIF [Security Traded] ="No" THEN "No Investigation"

ELSE "Investigate"

ENDIF

[Glenlim]

I've tried the formula, but it's not pulling the right data unfortunately. 

[davidskaife]

Hi @Glenlim 

Can you share some sample data and your expected output?