View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
forest8 forest8 is offline
external usenet poster
 
Posts: 41
Default Help with solving this if statement which uses a search for text s

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