Free Trial

Alteryx Auto Insights Discussions

Find answers, ask questions, and share expertise about Alteryx Auto Insights
Get started with

Alteryx Auto Insights

Lesson 1

Introduction to Alteryx Auto Insights

Lesson 2

Understanding Data with Alteryx Auto Insights

IF AND Function

igarcia7
5 - Atom

Can someone please help me with this formula?

From Excel: =IF(AND(O2="Cancelled / Declined",N2<>"Cancelled Request"),"In Signatures","")

 

How will I add in Alteryx?

5 REPLIES 5
DataNath
17 - Castor
17 - Castor

Hey @igarcia7, the equivalent of this in Alteryx would be:

 

IIF([O]='Cancelled / Declined' AND [N] != 'Cancelled Request','In Signatures','')
igarcia7
5 - Atom

Giving me an error for malformed

DataNath
17 - Castor
17 - Castor

@igarcia7 can you send a screenshot with your configuration? There's no issue with the expression - it's copy & pasted from my own example workflow where it's working perfectly.

alexnajm
17 - Castor
17 - Castor

You need to replace O and N in @DataNath 's Formula with the actual column names of your data

igarcia7
5 - Atom

Works perfectly! Thanks Guys