Re: Formula Excel Help

=IF(AND(OR(ISNUMBER(SEARCH("Jay", [@[Column F]])), ISNUMBER(SEARCH("Em", [@[Column F]]))),
        OR([@[Column B]]="Complete", [@[Column B]]="NA"),
        OR([@[Column C]]="Complete", [@[Column C]]="NA")),
   "Case Closed", 
   IF(OR(ISNUMBER(SEARCH("Jay", [@[Column F]])), ISNUMBER(SEARCH("Em", [@[Column F]]))), 
      "Case Open", 
      ""))

You can try This