F
forest8
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(SEARCH("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
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(SEARCH("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