yogi_Return One Of Three Strings Depending On Content of Row

Google Spreadsheet   Post  #2122

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-24-2017

question by Alex Lou:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/IIwZ3GR-YMs;context-place=forum/docs
Return one of three strings depending on row content

I am attempting to get Google Sheets to return one of 3 strings depending on the content of a row.

Specifically, if Column C contains the word "Failed" then return String 1 regardless of the content of its row. However, if Column C does not contain the word "Failed" and any other cell in the row contains "Failed" then return String 2. If no cell in the row contains "Failed" then return String 3.

Sample data and desired result here: https://docs.google.com/spreadsheets/d/1XDtn1DUzzZk_nodz-d4ZRdr0jVIvCz4BF_jNTFSHIqM/edit?usp=sharing

I have tried a number of things including REGEXMATCH and IF but no luck.

Any help would be appreciated!