Multiple Sequences Need to Be Complete/NA to Provide a Complete Value

aeverlyRR2024

Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results.

I am trying to write a formula where I'm looking for sequence values to be either Complete or N/A and based on those sequences being one of those two values, my formula results in reporting a Complete value.

Here are my sequences:

Sequence50

Sequence70

Sequence80

Sequence101

Essentially I'm looking for these sequences to be marked either "Complete" or "N/A" and once all (4) sequences have been marked with either result (complete or N/A) it results in the formula reporting a "Complete" result.

aeverlyRR2024

I believe I've got it - all testing is producing the correct outcome.

=IF(AND(OR(Sequence50 = "Complete", Sequence50 = "N/A"), OR(Sequence70 = "Complete", Sequence70 = "N/A"), OR(Sequence80 = "Complete", Sequence80 = "N/A"), OR(Sequence101 = "Complete", Sequence101 = "N/A")), "Complete")

aeverlyRR2024

I believe I've got it - all testing is producing the correct outcome.

=IF(AND(OR(Sequence50 = "Complete", Sequence50 = "N/A"), OR(Sequence70 = "Complete", Sequence70 = "N/A"), OR(Sequence80 = "Complete", Sequence80 = "N/A"), OR(Sequence101 = "Complete", Sequence101 = "N/A")), "Complete")