What AND does
AND combines multiple logical tests into one TRUE or FALSE result. It is most useful inside formulas like IF, conditional formatting rules, and filters where every condition must be satisfied.
Practical examples
Check whether two conditions are both true
=AND(B2>=70,C2="Yes")
Returns TRUE only when the score in B2 is at least 70 and the status in C2 is Yes.
Use AND inside IF
=IF(AND(D2>=DATE(2026,1,1),D2<=DATE(2026,12,31)),"In range","Out of range")
This labels a date as in range only when it falls between the two boundary dates.
Common mistakes and notes
AND returns TRUE or FALSE, not a label
If you need a word like Approved or Review, wrap AND inside IF. On its own, AND only returns a boolean result.
Every condition must pass
If even one logical test is FALSE, the entire result is FALSE. Use OR when you want any one of the conditions to pass.
Text comparisons must be quoted
Conditions such as C2="Yes" need quotation marks around the text value. Without quotes, Excel treats the text as a name reference.