AND

Check if multiple conditions are all true at the same time.

Use AND when you need all requirements met before something happens: qualifying for a discount requires membership AND minimum purchase, approving a form requires all fields filled, or triggering an action needs multiple criteria satisfied.

How it works

AND(condition1, condition2, condition3, ...)

condition1, condition2, ... - Any number of conditions to check

Returns TRUE only if every single condition is true. If even one is false, the whole thing is false.

Examples

Premium discount qualification

Give a discount only if customer is a member AND order exceeds €100.

AND(IS_MEMBER, ORDER_TOTAL > 100)

Both conditions must be true for the discount to apply.

Required form fields

Check that all required fields are filled before allowing submission.

AND(NOT(ISEMPTY(NAME)), NOT(ISEMPTY(EMAIL)), NOT(ISEMPTY(PHONE)))

Returns TRUE only if name, email, and phone all have values.

Product eligibility

Show a product only if it's in stock AND in the correct category AND within budget.

AND(STOCK > 0, CATEGORY = "Premium", PRICE < MAX_BUDGET)

All three conditions must be met.

Service availability

Determine if a service slot is available based on multiple factors.

AND(DAY != "Sunday", TIME >= 9, TIME <= 17, BOOKINGS < MAX_CAPACITY)

Checks day, time window, and capacity all at once.

Using AND with IF

Combine AND with IF to create conditional logic based on multiple requirements.

IF(
   AND(QUANTITY > 5, FINISH = "Gold"),
   PRICE * 0.9,
   PRICE
)

Apply discount only if buying more than 5 items AND finish is Gold.

Common mistakes

Treating empty values as true - Empty strings, 0, and false all count as false
Using AND when OR makes more sense - If only one condition needs to be true, use OR instead
Forgetting parentheses - AND(A > 5, B < 10) not AND A > 5, B < 10
Over-complicating - Sometimes separate IF statements are clearer than complex AND chains

How AND evaluates

AND stops checking as soon as it finds a false condition. If the first condition is false, it doesn't bother checking the rest.

When to use alternatives

Only one condition needs to be true: Use OR instead
Opposite logic needed: Use NOT to flip the result
Many conditions: Consider breaking into separate variables for readability

OR, NOT, IF

Was this helpful?

AND