Hello Everyone
I need an advice from exel masters
I trying to create formula like this:
=IF(ISNUMBER(AND(SEARCH("text1";A1)),(SEARCH("text2",B1))),"text3")), but does not work
Formula says that If A1 is found to contain the text1, and B1 is found to contain the text2, then display text3
I need an advice from exel masters
I trying to create formula like this:
=IF(ISNUMBER(AND(SEARCH("text1";A1)),(SEARCH("text2",B1))),"text3")), but does not work
Formula says that If A1 is found to contain the text1, and B1 is found to contain the text2, then display text3