AND Function in Excel
Beginner
Returns TRUE if all arguments are TRUE, FALSE if any argument is FALSE.
Syntax
=AND(logical1, [logical2], ...)Example
Use Case
Check if a student passed all subjects (all grades > 60).
Common Errors to Avoid
- Returns FALSE if any single condition is FALSE
- Cannot use with full column references if they contain text
- Often combined with IF: =IF(AND(A1>10, B1<20), 'Yes', 'No')
Pro Tips
Use inside IF functions for multiple criteria. For row-by-row evaluation across ranges, combine with array formulas. Consider using * (multiplication) instead: (A1>10)*(B1<20) returns 1 for TRUE, 0 for FALSE.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →