IF AND Function

[igarcia7]

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?

[DataNath · Accepted solution]

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

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

[igarcia7]

Giving me an error for malformed

[DataNath]

@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 · Accepted solution]

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

[igarcia7]

Works perfectly! Thanks Guys