All functions / Logical
AND
TRUE only if every condition is TRUE.
Syntax
=AND(logical1, [logical2], …)
Arguments
logical: Conditions to test.
Example
=AND(B2>0, C2="Yes") → TRUE when both hold
All functions / Logical
TRUE only if every condition is TRUE.
=AND(logical1, [logical2], …)
logical: Conditions to test.=AND(B2>0, C2="Yes") → TRUE when both hold