| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help with formula (IF or perhaps array)
=IF(ISERROR(FIND("No",B1&C1&D1)),"Yes","No")
-- Gary''s Student - gsnu200789 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Can this be done using an array formula ? | Excel Worksheet Functions | |||
| Need Help With Array Formula | Excel Discussion (Misc queries) | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
| Array Formula | Excel Worksheet Functions | |||
Linear Mode
