Formula Library
AND
logicalReturns TRUE if all conditions are true, FALSE if any condition is false.
Syntax
=AND(logical1, [logical2, ...])Example
Excel
=AND(A2>0, B2="Active", C2<100)Returns TRUE only if A2 is positive, B2 is "Active", AND C2 is less than 100.
Tips & Notes
- →Usually nested inside IF: =IF(AND(...), "Yes","No")
- →Can accept up to 255 conditions
- →Short-circuits: stops at first FALSE
See Also
Need a custom AND formula?
Describe exactly what you need and get the formula generated instantly.