Sunday, August 13, 2017

yogi_Return X If The Row (columns A:E) Does Not Contain one Of The Specified Items

Google Spreadsheet   Post  #2225

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Aug-13-2017
question by: Dana Sturdivant!topic/docs/-EnxHCZ-MIA;context-place=mydiscussions

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