Help with adding two IF formulas within a single cell

[lchalk]

=IF(ISNUMBER(SEARCH("cannot be maintained by some operators",C26)),"4",F63)+(ISNUMER(SEARCH(''unobtainable by some operators'',E26)),''4'',F63)

 

[lchalk]

=IF(ISNUMBER(SEARCH("cannot be maintained by some operators",C26)),"4",F63)+(ISNUMER(SEARCH(''unobtainable by some operators'',E26)),''4'',F63)

This is my current formula, any ideas why it is not working?

 

[njimack]

=IF(ISNUMBER(SEARCH("cannot be maintained by some operators",C26)),4,F63)+IF(ISNUMBER(SEARCH("unobtainable by some operators",E26)),4,F63)

 

[lchalk]

=IF(ISNUMBER(SEARCH("cannot be maintained by some operators",C26)),4,F63)+IF(ISNUMBER(SEARCH("unobtainable by some operators",E26)),4,F63)

Thanks for the quick response Neil, this has helped a little, however, I have realised I don't need to add the values and it needs to be, the first IF or the second IF as the current formula creates a value of 8 and need it to equal 4.

 

[njimack]

There are 3 possible options
1 - C26 & E26 both contain the text being searched for
2 - Either of C26 or E26 contain the text being searched for
3 - Neither cell contains the text being searched for

In each case, what value do you want returned?

 

[lchalk]

There are 3 possible options
1 - C26 & E26 both contain the text being searched for
2 - Either of C26 or E26 contain the text being searched for
3 - Neither cell contains the text being searched for

In each case, what value do you want returned?

thanks again for the response I seem to have found that the following formula works in my case:

=(IF(ISNUMBER(SEARCH("cannot be maintained by some operators",C26)),4,IF(ISNUMBER(SEARCH("unobtainable by some operators",E26)),4,F63)))

Lewis