First
The first logical value or array of logical values.
Other
Additional logical values or arrays of logical values.
Returns
TRUE if, and only if, all parameters are TRUE and FALSE otherwise.
Returns TRUE if all parameters are TRUE and FALSE otherwise. AND (TRUE, TRUE, FALSE) AND (TRUE; TRUE; FALSE) returns FALSE, because not all parameters are TRUE, but AND (TRUE, TRUE, TRUE) AND (TRUE; TRUE; TRUE) returns TRUE.
Use AND, OR, NOT and XOR in conjunction with IF to express logical conditions.
This formula returns 2 only if Value1 is 20 and Value2 is 40, and 4 otherwise:
The formula can also be written using the && operator (which is not commonly supported by spreadsheets):
&& is written between the values to test, instead of before them, which can make formulas easier to read.
Examples
Returns 2 only if Value1 is 20 and Value2 is 40. Otherwise, 4 is returned.
Returns 2 only if Value1 is 20 and Value2 is 40. Otherwise, 4 is returned. This example uses the && operator, which is not commonly supported by spreadsheets, instead of the AND function.
Returns TRUE, because all elements of the array are TRUE.
Returns FALSE, because a single element of the array is FALSE.
Returns FALSE, because the second parameter is FALSE.