Excel - IF function with multiple words
Solved
Related:
- If cell contains text then return value multiple conditions
- If cell contains (multiple text criteria) then return (corresponding text criteria) - Best answers
- Multiple if statements in excel with text - Best answers
- If a cell has text then return value ✓ - Excel Forum
- Conditional formatting if cell contains text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Wow equipment return ✓ - Network Forum
- What function can automatically return the value in cell c77 ✓ - Excel Forum
5 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Updated on Dec 9, 2018 at 12:39 PM
Updated on Dec 9, 2018 at 12:39 PM
try this formula
=IF(OR( ISNUMBER(SEARCH("apple",B4)), ISNUMBER(SEARCH("banana",B4)), ISNUMBER(SEARCH("carrot",B4))), "yes", "no")
Mar 25, 2014 at 10:13 PM
Jul 23, 2014 at 10:12 PM