Forum Discussion
Solved
Formula Excel Help
Hi, I'd like to create a formula which looks at column F and if it contains words, "Jay", "Em" then to go to column B AND C and if they both state 'Complete' or 'NA' then to return words in colum...
Try this formula:
=IF(OR([@[Name]]={"Jay","Em"}), IF(SUM(COUNTIF(Table1[@[Servicing Status]:[Complaint Status]], {"Complete","NA"}))=2, "Case Closed", "Case Open"), "")
(Change Name to the real name of that column)
=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