I am trying to create a formula as follows:

Cell B2: should read "Plant"

Cell B3: should not contain word "Fines"

Managed to create a formula that gives me the right output when both are

conditions are met, though having problem reversing the false into true for

Cell B3

Formula created is as follows:

IF(AND(ISNUMBER(FIND("Plant",B2))*ISNUMBER(SEARCH("Fines",B3))),"Include","N/A")

Where do I go wrong?

Thanks a lot!

## Bookmarks