Syntax
AND(logical1, [logical2, ...])
| Parameter | Description |
|---|---|
| logical1 | Parameter of the AND function. |
| [logical2 | (Optional.) Parameter of the AND function. |
| ...] | Parameter of the AND function. |
Examples
Check if score is in a range
Formula
=IF(AND(B2>=80, B2<=90), "B Grade", "Other")
Returns: "B Grade" if the score is between 80 and 90 inclusive, "Other" otherwise
Verify all fields are filled
Formula
=IF(AND(A2<>"", B2<>"", C2<>""), "Complete", "Incomplete")
Returns: "Complete" only if all three cells contain data
Multiple criteria for bonus
Formula
=IF(AND(C2>50000, D2>=4), C2*0.05, 0)
Returns: a 5% bonus if sales exceed $50K AND rating is 4+, otherwise 0
Common Errors
#VALUE!
One of the conditions evaluates to a text string instead of TRUE/FALSE. Make sure all arguments are logical comparisons.
Tips
Short-circuit behavior
In most spreadsheets, AND evaluates all conditions even if the first is FALSE. This differs from programming languages.
AND in conditional formatting
Use AND in conditional formatting rules to highlight rows meeting multiple criteria simultaneously.
More than 2 conditions
AND supports many conditions: =AND(A1>0, B1>0, C1>0, D1>0) checks all four at once.
Try AND in Viztab
Import your data and use AND with 370+ other formulas. No signup required.
Open Viztab