Forum Discussion
Formula Excel Help
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)
Let's say column F has header Name.
=IF(OR([@Name]={"Jay", "Em"}), IF(OR(AND([@[Servicing Status]]:[@[Complaint Status]]="Complete"), AND([@[Servicing Status]]:[@[Complaint Status]]="N/A"))), "Case Closed", "Case Open"), "")
Something doesn't seem right as it's only returning Case Open, no Case Closed. I should have many Case Closed
Oh wait! You wrote NA and I used N/A. Sorry about that.
=IF(OR([@Name]={"Jay", "Em"}), IF(OR(AND([@[Servicing Status]]:[@[Complaint Status]]="Complete"), AND([@[Servicing Status]]:[@[Complaint Status]]="NA"))), "Case Closed", "Case Open"), "")
- Hi I changed the formula to 'NA' but that didn't make any difference
Again:
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"?
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"?