IF an array..

[michael]

I am using the following formula:
=if( B2..Z2="n/a","Yes","No")
in attempt retreive a "Yes" if any within the data set has a "n/a".
The formula only retruns a"Yes" if the B2 cell is "n/a" - and otherwise
returns "No" when "n/a" exists within the group.

What is wrong?

 

[Gary''s Student]

=IF(COUNTIF(B2:Z2,"n/a")>0,"Yes","No")