Yes or No for adjacent cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=if(countif(b8:m8,"y")>0,"yes","no")

or if you want the cell to look blank:

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