And Function Excel

Uses the AND function, a logical function, to determine whether all conditions in a test are TRUE.

The AND function is an excel function that is used to get a logical value of TRUE or FALSE from a comparison of 2 or more conditions.

This is comparison table the AND function with 2 conditions.

Condition 1	Condition 2	And Function
TRUE	TRUE	TRUE
TRUE	FALSE	FALSE
FALSE	TRUE	FALSE
FALSE	FALSE	FALSE

AND function in excel is =AND(logical1;logical2;...)

For example you can type =AND(A2;B2)

And then press Enter. The result like this.

The result is like a comparison table.

The AND function returns a logical value of TRUE if all the conditions of the arguments being tested are met or evaluates to TRUE and returns a value of FALSE if one of the arguments is not met or evaluates to FALSE.