What about? (non-array entered)

=IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes","A pple")

If this post helps click Yes
---------------
Jacob Skaria


"T. Valko" wrote:

Forgot to mention that when you are searching
multiple cells...you need to have mutiple SEARCH
conditions within COUNT..for E13, E14 etc;....
=IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14), SEARCH("F",YS!E14)),"Yes","Apple")

Array entered** :

=IF(COUNT(SEARCH({"GO","D","F"},YS!E13:E14)),"Yes" ,"Apple")

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
Forgot to mention that when you are searching multiple cells...you need to
have mutiple SEARCH conditions within COUNT..for E13, E14 etc;....

=IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E14),S EARCH("F",YS!E14)),"Yes","Apple")


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try the below
=IF(COUNT(SEARCH("GO",YS!E13),SEARCH("D",YS!E13),S EARCH("F",YS!E13)),"Yes","Apple")

If this post helps click Yes
---------------
Jacob Skaria


"forest8" wrote:

Hi

I am using Excel 2007 and trying to fix this formula.

In exvcel, there are several questions which could be used in the
result of
the same cell.

This is what I need fixed:

=IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple")

What I'm trying to do is put multiple conditions on this cell.YS!E13
contains the word "GO", or YS contains either a "D" or "F", then the
cell
should return "YES", if not, it should return "Apple".

I can't get this formula to work with this complex equation.

Thank you