Google Spreadsheet Post #2225
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Aug-13-2017
question by: Dana Sturdivant
question by: Dana Sturdivant
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/-EnxHCZ-MIA;context-place=mydiscussions
https://docs.google.com/
Return "x" if row does not contain "dog" OR "cat"
I need to write a formula that returns an x if the adjacent row does not contain any of the specified text strings.
Example: Specified text: "Dog" "Cat"
Row 1 does not return an x because it has the text "Dog" and/or "Cat"
Row 2 returns an x because it does not contain the text "Dog" or "Cat"
I have attached a sample case with text in cells A2:E5, and with the desired result in F2:F5
No comments:
Post a Comment