A parcel is ready only when the inspection is signed and either local pickup or a locker is confirmed. A formula should reject a parcel with two collection routes if the signature is missing.
Separate the prerequisite from the alternatives
Put Signed, Local pickup and Locker in B, C and D. Enter Yes or No for each. In E2, enter:
=AND(B2="Yes",OR(C2="Yes",D2="Yes"))
Illustrated inputs. The route columns are alternatives and the signed check is required.
The inner OR accepts either route, including both together. AND also requires the signed check.
Test the rows you might misread
Yes, Yes, No and Yes, No, Yes both return TRUE. So does Yes, Yes, Yes. No, Yes, Yes returns FALSE because the sign-off is missing. Yes, No, No returns FALSE because no route is confirmed.

Illustrated checks. A route alone or a sign-off with no route leaves the result false.
Fill down after testing. If blank means “waiting for a response,” keep that distinction in the input columns. The formula compares each input with the literal text Yes.



