Yes or No for adjacent cells

[Guest]

I want cell N8 to display "Yes" if any cell between B8 and M8 have a "Y" in
them. I have tried the array {=IF(B8:M8="Y","Yes","No")} but it only reads
the first cell and disregards any "Y" in any other cell. If the cels have "N"
in them then N8 can remain empty.
Any ideas?

 

[Dave Peterson]

=if(countif(b8:m8,"y")>0,"yes","no")

or if you want the cell to look blank:

=if(countif(b8:m8,"y")>0,"yes","")