No, the point here is that I'm messing with you! <g

If you don't want to use an array formula, and since we don't know what the
possible cell entries could be, something like this should be fairly safe:

=IF(COUNT(SEARCH({"GO","D","F"},E13&"^^"&E14)),"Ye s","Apple")

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
True..That depends on the data..Thanks Biff. The point here is that for
multiple range of cells we can use the array entered formula

"T. Valko" wrote:

What about? (non-array entered)
=IF(COUNT(SEARCH({"GO","D","F"},E13&E14)),"Yes"," Apple")

Yeah, that's a possibility. It depends on the data.

What would happen if this was the data:

E13 = G
E14 = O

--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
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