Return TRUE only when every condition is true.
Syntax
AND(logical1, [logical2], …)Arguments
logical1required
The first condition to test.
logical2…optional
Additional conditions.
AND tests several conditions at once and returns TRUE only if all of them hold. It's most useful inside IF, where you need multiple criteria to be met before acting. Use OR when any one condition is enough.
=AND(B2>0, C2>0)→TRUETRUE only when both values are positive.
=IF(AND(B2>=60, C2>=60), "Pass", "Fail")→PassPasses only when both scores clear 60.
List the conditions
Separate each TRUE/FALSE test with a comma.
Nest inside IF
Put AND in IF's logical test to branch on multiple criteria.
Use AND when every condition must be true; use OR when any single condition is enough.