🌗 The "One or Other" Gate

Goal: Check Discount Eligibility.
Rule: You can use a Coupon OR get the Sale Price, but NOT BOTH.

Ready...

💻 Formula Structure

=XOR(logic1, [logic2], ...)
  • 1. Logic 1: Has Coupon? (TRUE/FALSE)
  • 2. Logic 2: Is Sale Item? (TRUE/FALSE)
  • Result: TRUE if odd number of inputs are True. (For 2 inputs: One, but not both).
-- Allow if Coupon OR Sale (Exclusive)
=XOR( B2="Yes", C2="Yes" )
Discount Allowed?
-

⚠️ Common Pitfalls

🚫 Confusion with OR
OR allows "Both". XOR forbids "Both".
Use XOR when choices are mutually exclusive (e.g., Male/Female, Day/Night).
🚫 More than 2 Inputs
With 3+ inputs, XOR returns TRUE if an ODD number of them are True. It gets confusing quickly!