Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

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

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

@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