Forum Discussion

Justin_A's avatar
Justin_A
Copper Contributor
Jan 05, 2025
Solved

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...
  • HansVogelaar's avatar
    Jan 06, 2025

    Use

    =IF(ISNUMBER(SEARCH("abc", cell_reference)), xyz, "")

Resources