Forum Discussion
Justin_A
Jan 05, 2025Copper Contributor
Conditional formula based on whether a cell contains a specific string of text
I would like to create a conditional formula that would work like this: "if this cell contains the text string 'abc', then do xyz (otherwise, do nothing). This is not the same as "if the data in thi...
- Jan 06, 2025
Use
=IF(ISNUMBER(SEARCH("abc", cell_reference)), xyz, "")
HansVogelaar
Jan 06, 2025MVP
Use
=IF(ISNUMBER(SEARCH("abc", cell_reference)), xyz, "")