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

A sample worksheet places the signed check, local pickup and parcel locker options in columns B through D.

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.

A sample truth table includes both single-route passes, a double-route pass and two failure cases.

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.

Microsoft’s AND and OR reference.