multiple conditions on this cell.YS!E13
=IF(OR(ISNUMBER(SEARCH("go",YS!E13)),(ISNUMBER(SEA RCH("D",YS!E14)),(ISNUMBER(SEARCH("F",YS!E14)))))) ,"Yes","Apple")

Your formula is referencing 2 cells, E13 and E14.

Try it like this:

=IF(COUNT(SEARCH({"go","D","F"},YS!E13)),"Yes","Ap ple")

--
Biff
Microsoft Excel MVP


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