AND()
Returns TRUE only if every argument is true.
AND(logical1, [logical2], ...)AND evaluates a list of conditions and returns TRUE only if all of them hold, FALSE if even one doesn't. It's almost always used inside IF, since AND by itself just returns TRUE or FALSE.
Combine with OR to build compound conditions like "both A and B, or C."
Arguments
- logical1
- The first condition to test.
- logical2, ...optional
- Additional conditions to test — all must be TRUE.
Examples
=AND(B2>=60, C2="Complete")→TRUE
TRUE only if the score is 60+ AND status is Complete.
=IF(AND(B2>=60, C2="Complete"), "Pass", "Fail")→Pass
AND nested inside IF to gate on two conditions at once.