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....
- =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")
=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")
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.
