AND

See also A-Z Spreadsheet Function List

Description Returns True if all arguments are true; returns False if at least one argument is false.

Syntax AND(logical_list)

logical_list is a list of conditions separated by commas. You can include as many as 30 conditions in the list. The list can contain logical values or a reference to a range containing logical values. Text and empty cells are ignored. If there are no logical values in the list, #VALUE! is returned.

See Also IF , NOT , and OR functions

Examples AND(1+1=2, 5+5=10) returns True because both arguments are true.

         AND(TRUE(), FALSE()) returns False