The AND function returns either a TRUE or a FALSE. It returns a TRUE if all of its arguments are true and it returns a FALSE if any of its arguments are not true.

The Syntax for the AND function is:
AND(logical1, [logical2], …)

The AND function can be used to evaluate up to 255 logical conditions.
The figure below shows the AND function with three logical conditions. All three of these conditions are True therefore the function returns a TRUE.

The last condition in the figure below is false. The value in cell D1 is not equal to the value in cell F1. The AND function therefore returns a False because even if only one of
the logical conditions is false it will return a False.