AND function

Description

This AND function is a logical function used to require more than one condition at the same time. AND return either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use = AND(A1>0, A1<0). The AND function can be used as the logical test inside the IF function to avoid extra nested IFs and can be combined with the OR function.

​

Objective

Test multiple condition with AND.

​

Syntax

=AND(logical1, logical2,....)

​

Arguments

logical1 - the first condition or logical value to evaluate.

logical2 - [optional] the second condition or logical value to evaluate.

​

​