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?