AND


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

Syntax AND ( logical_list )
Argument Description
logical_list 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, the error #VALUE! is returned.

Examples This function returns True because both arguments are true:

AND(1+1=2, 5+5=10)

This function returns False:

AND(TRUE(), FALSE())

See Also NOT, OR, ROW