Hi,
I have got a formula that determines if a cell contains a certain word/text and provides me with a desired text outcome if that is the case
I have found 2 ways of doing this:
=IF(ISNUMBER(SEARCH("abc",A9)),"result","")
=IF(COUNTIF(A9,"*abc*"),"result","")
However i cant seem to figure out how to do the same for two criteria. I.e if cell A9 contains somewhere within it 'abc' and a '?' then show 'result' if it doesn't contain these 2 words then show 'noresult'
Could anyone help?
Thanks
I have got a formula that determines if a cell contains a certain word/text and provides me with a desired text outcome if that is the case
I have found 2 ways of doing this:
=IF(ISNUMBER(SEARCH("abc",A9)),"result","")
=IF(COUNTIF(A9,"*abc*"),"result","")
However i cant seem to figure out how to do the same for two criteria. I.e if cell A9 contains somewhere within it 'abc' and a '?' then show 'result' if it doesn't contain these 2 words then show 'noresult'
Could anyone help?
Thanks