AND

Returns TRUE if all inputs are TRUE.

Function syntax

AND(logical1, logical2, ...)

Arguments:

• logical1, logical2, …: Two or more expressions that evaluate to TRUE or FALSE.

Examples

• AND(A5>3, SUM(revenue{})>SUM(cost{})) - TRUE only if both conditions are TRUE.
• AND(TRUE, TRUE, FALSE) - Returns FALSE because not all inputs are TRUE.