Jna3276Copper ContributorSep 09, 2024Re: Formula Excel HelpI'd like to add word withdrawn to the list, if this is found in both or either Servicing / Complaint Status then the return values should be Case closed, like it does for Complete or NA
1 ReplyReplies sorted by NewestSort ByMost LikedOldestNewestHansVogelaarMVP to Jna3276Sep 09, 2024Jna3276 Thanks. Since you're still looking at 2 columns, you should use =2, not =3: =IF(OR([@[Name]]={"Jay","Em"}), IF(SUM(COUNTIF(Table1[@[Servicing Status]:[Complaint Status]], {"Complete","NA","Withdrawn"}))=2, "Case Closed", "Case Open"), "")
HansVogelaarMVP to Jna3276Sep 09, 2024Jna3276 Thanks. Since you're still looking at 2 columns, you should use =2, not =3: =IF(OR([@[Name]]={"Jay","Em"}), IF(SUM(COUNTIF(Table1[@[Servicing Status]:[Complaint Status]], {"Complete","NA","Withdrawn"}))=2, "Case Closed", "Case Open"), "")
