Adding an "AND" condition to a formula

[easybpw]

Hello and thanks in advance for your help. I'm using the formula below without issue but now need to add an "AND" condition to the formula. Struggling to get it right. Any help is appreciated. Note that I'm adding the 2nd half of the bolded section. Without the 2nd piece the formula works fine but now I need to also eliminate anything in the transaction narrative column that contains "AXP". So if "transaction amount" is less than 15000 AND transaction narrative does not include "AXP". Just realized that the formula also cannot contain "chgbck" in the narrative. So it needs to be less than 15000 and narrative cannot have "AXP" or chgbck" in it. And the formula is referencing a table. Using Office 365.

=IF(OR(ISNUMBER(SEARCH("AMERICAN",$G4)))=TRUE,IF([@[Transaction Amount]]<15000,IF([@[Transaction narrative]]<>"AXP","Amex Phone",""),))

 

[dreid1011]

If I am not mistaken, you could simplify the formula a bit. This seems to do the same thing, see if it works:

=IF(AND(ISNUMBER(SEARCH("AMERICAN",$G4))=TRUE,Table1[@[Transaction Amount]]<15000,Table1[@[Transaction Narrative]]<>"AXP",Table1[@[Transaction Narrative]]<>"chgbck"),"Amex Phone","")