Need help with formula (IF or perhaps array)
 

We did a survey and put the responses in Excel (2003). Responses to questions
1-3 have a qualifier. In other words, the response either €œYes€� or €œNo€� is
based on a qualifier 1, 2, or 3. Heres a sample of our tabulation
spreadsheet:

A B C D E
1 Q1 Q2 Q3 Tab
2 Joe Yes,1 No,3 Yes,1 No
3 Bill Yes,2 Yes,3 Yes,1 Yes


The final tabulation is €œNo€� if €œNo,x€� is listed in any of the 3 columns.

I want to enter a formula in the Tab column that will look for €œNo€� in the 3
Q columns and if found in any will return €œNo€� and if not found in any will
return €œYes€�.

Ive tried =IF(ISNUMBER(FIND(€œNo€�,B2:D2))),€�No€�,€�Ye s€�) but it does not work.
It returns €œYes€� for all rows. Ive tried enclosing the formula in braces and
running as an array but that doesnt work either.

Thanks for your help.
Novice

Need help with formula (IF or perhaps array)
 

=IF(ISERROR(FIND("No",B1&C1&D1)),"Yes","No")

--
Gary''s Student - gsnu200789

Need help with formula (IF or perhaps array)
 

Thank you so very much!!!

"Gary''s Student" wrote:

=IF(ISERROR(FIND("No",B1&C1&D1)),"Yes","No")

--
Gary''s Student - gsnu200789