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)
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
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"?
- I'd like it to return case closed in this senerio