AND

AND function returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.

The logical1 and logica2 conditions are required and you can optionally add up to 255 conditions.

SAMPLE: AND(A1=1,A2=2,A3=3)

will look like the following table, where 1 represents TRUE:

This table shows 0 in the formula result, because not all conditions are evaluated as true: