IF AND Function
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
igarcia7
5 - Atom
‎08-28-2024
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Labels:
- Labels:
- Data Connection
5 REPLIES 5
DataNath
17 - Castor
‎08-28-2024
08:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @igarcia7, the equivalent of this in Alteryx would be:
IIF([O]='Cancelled / Declined' AND [N] != 'Cancelled Request','In Signatures','')
‎08-28-2024
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Giving me an error for malformed
DataNath
17 - Castor
‎08-28-2024
08:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
‎08-28-2024
08:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You need to replace O and N in @DataNath 's Formula with the actual column names of your data
‎08-28-2024
10:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Works perfectly! Thanks Guys