Forum Discussion
John23785
Jul 30, 2024Copper Contributor
If Or Statement, Cell contains specific text
Hello - I am trying to write a formula that says If Name contains Fred1, Fred2, or if Column B says Blue, or Column C says Leave, then Include (True) or Exclude (False). For example: Name Sp...
HansVogelaar
Jul 30, 2024MVP
=OR(Name_cell="Fred1", Name_cell="Fred2", Specification_cell="Blue", Where_cell="Leave")
will return TRUE if any of the conditions is met, FALSE otherwise.
John23785
Jul 30, 2024Copper Contributor
Thanks Hans, now if "Name" cell contains Fred1 like Fred1LastName, how could I specify it for just Fred1?