Return TRUE only when every condition is true.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
AND(logical1, [logical2], …)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)Result: TRUE
TRUE only when both values are positive.
=IF(AND(B2>=60, C2>=60), "Pass", "Fail")Result: Pass
Passes only when both scores clear 60.
Use AND when every condition must be true; use OR when any single condition is enough.