AND
The AND function returns TRUE if all arguments evaluate to TRUE, and returns FALSE if any argument evaluates to FALSE.
Syntax
=AND(logical1, [logical2], ...)
Parameters
logical1
: The first condition to evaluatelogical2
, ...: Additional conditions to evaluate (optional)
Examples
=AND(TRUE, TRUE) // Returns TRUE
=AND(TRUE, FALSE) // Returns FALSE
=AND(5>3, 10<20) // Returns TRUE