Forum Discussion
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)
Thank you for this.
Something doesn't seem right as it's only returning Case Open, no Case Closed. I should have many Case Closed
Something doesn't seem right as it's only returning Case Open, no Case Closed. I should have many Case Closed
What do you want to return if column B has "Complete" and column C has "N/A"? And what if column B has "N/A" and column C has "Complete"?
