Hello!

I'm working on an assignment - I have three values: "Yes", "No" and "Maybe".

A B C D E
1 Yes Yes Maybe Yes
2 No Maybe Yes Yes

I need a formula for Column E that fulfills the following conditions:

a. If the value in the rows is either "Yes" OR "Maybe", return "Yes"


b. If even one of the values in the rows is "No", return "No"

I've been unable to figure out a formula for this as it includes a group of cells. Please help!

Thanks in advance!