Function reference

AND in Excel & Google Sheets

AND is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 beginnerBuild a custom AND formula →

When to use AND

Flag rows where both a status is active AND a value exceeds a threshold, or mark leads as qualified when they meet any one of several criteria.

Worked examples (1)

Conditional Logicbeginner

Combine conditions with AND and OR

=IF(AND(B2="Active",C2>1000),"Qualify","Skip")

Open formula AND reference

Common errors with AND

AND/OR used without IF

AND and OR return only TRUE or FALSE. Wrap them in IF to return different values for each outcome — IF(AND(...),value_if_true,value_if_false).

Confusing AND and OR results

AND requires every condition to be true. OR needs just one. If results are unexpected, check whether you meant AND (stricter) or OR (looser).

Frequently asked questions

Can I nest AND inside OR?

Yes — =IF(OR(AND(B2="A",C2>5),D2="VIP"),"Yes","No") is valid. B2 must be "A" AND C2>5 satisfies the OR, as does D2="VIP" alone.

Need a custom variation?

Describe your specific AND problem and get a formula written for your exact data.

Open generator with AND