CODEWITHSUNDEEP
excel
Will
Will

Reputation: 35

how to return yes if one of the values contains a yes

I have a row of values that is either Yes or No.

What formula can I use so as long as one of them cells is a Yes, it returns a yes. Or another way to explain it, to prompt a No requires all cells to be a No.

Thanks

Upvotes: 0

Views: 6514

Answers (1)

Dude_Scott
Dude_Scott

Reputation: 641

Assuming your yes and no’s are in cells A1:A10. Update the range in the COUNTIF as needed. 

=IF(COUNTIF(A1:A10,”Yes”)>0,”Yes”,”No”)

Upvotes: 1

Related Questions