Which formula will look at multiple columns and return a result

Mckes21 · Oct 24, 2016

I have three columns that could have 1 yes and 2 no's or all 3 no's, I need to know which formula will look at all 3 columns and tell me if there is a "yes", if and if and are not working for me.

AliGW · Oct 24, 2016

This will return 1 if any "yes" is found, and 0 if not:

=IFERROR(SEARCH("yes",A1&B1&C1),0)

And here's another option (there are many):

=IF(COUNTIF(A1:C1,"yes")>0,1,0)

Which formula will look at multiple columns and return a result

Mckes21

New member

AliGW

Administrator