Adding two Find formulas together

[ensmith]

I am trying to add two find formulas together

=IF(FIND("Negative",P2),"Negative"),(IF(FIND("Positive",P2),"Positive"))

Thanks.

 

[shyy]

Is it just binary choices?

If so, this will put in Positive if the cell doesn't contain the word negative

=IF(COUNTIF(P2:P2,"*Negative*")=1,"Negative","Positive")

If its just straight up Positive or Negative

=IF(COUNTIF(P2,"Negative")=1,"Negative",IF(COUNTIF(P2,"Positive")=1,"Positive",""))

 

[Aladin Akyurek]

I am trying to add two find formulas together

=IF(FIND("Negative",P2),"Negative"),(IF(FIND("Positive",P2),"Positive"))

Thanks.

Also...

=LOOKUP(9.99999999999999E+307,SEARCH($A$2:$A$3,P2),$A$2:$A$3)

where A2:A3 house the words Negative and Positive.