SOLVED
IF Formula with Contains
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
insomned
8 - Asteroid
09-14-2021
02:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
Is it possible to write an IF formula with "contains", so if the column X contains "Hello" output "Yes" in the new column?
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Developer
2 REPLIES 2
Emil_Kos
17 - Castor
09-14-2021
02:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @insomned,
This is the formula that you are looking for:
IIF(Contains([Column X], 'Hello'), 'Yes', 'No’)
09-14-2021
02:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!!