Formula help - Is my "<>" correct

[easybpw]

Hello,

The below formula using Office 365 and looking at a table is still pulling the data that I don't want it to contain. Is my <> incorrect? I can't figure out why it is pulling the data.

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

 

[Fluff]

Duplicate to: Adding an "AND" condition to a formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.