Yes or No for adjacent cells
 

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?

Yes or No for adjacent cells
 

Try...
{=IF(Or(B8:M8="Y"),"Yes","No")}
--
JNW


"JKWParrott" wrote:

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?

Yes or No for adjacent cells
 

Thanks, worked like a charm.

"JNW" wrote:

Try...
{=IF(Or(B8:M8="Y"),"Yes","No")}
--
JNW


"JKWParrott" wrote:

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?

Yes or No for adjacent cells
 

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

or if you want the cell to look blank:

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



JKWParrott wrote:

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