Forum Discussion
Solved
Complex “if” formula using multiple cells
Please help me: if ab1, ac1, ad1, ae1, af1 is “a- successful” and/or “b-partial successful” yes if not no. Each of the 5 cells must have either or “a-successful” or “b-partial successful” to be true. For you kind assistance please. With thanks.
Dawn
- =IF(AND(OR(AB1="a-successful", AB1="b-partial successful"),
OR(AC1="a-successful", AC1="b-partial successful"),
OR(AD1="a-successful", AD1="b-partial successful"),
OR(AE1="a-successful", AE1="b-partial successful"),
OR(AF1="a-successful", AF1="b-partial successful")),
"Yes",
"No")
- Thank you Detlef_Lewin. Your input is valuable. I decided to do the count as well. The formula you shared worked perfectly. Cheers!!! Dawn.
- =IF(AND(OR(AB1="a-successful", AB1="b-partial successful"),
OR(AC1="a-successful", AC1="b-partial successful"),
OR(AD1="a-successful", AD1="b-partial successful"),
OR(AE1="a-successful", AE1="b-partial successful"),
OR(AF1="a-successful", AF1="b-partial successful")),
"Yes",
"No")- Ok Thank you so much @NickolinoDE. I will give it a try right now. best regards. Dawn.
- Absolutely perfect. All done. Thanks again NikolinoDE. Dawn.
