FUNCTION CATALOGUE / LOGICAL
AND Excel function
Returns TRUE if every condition is true.
Correct sentence to use
Check whether all of these conditions are true: [conditions].
Modify this query in PlainFormula →Example formula
=AND(A2>0,B2<10)
Returns TRUE only when all arguments are TRUE.
Syntax
AND(logical1, [logical2], …)
Argument signature: logical1, [logical2], …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.