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