Description
Returns True if all arguments are true; returns False if at least one argument is false.
Syntax
AND ( logical_list )
| Parameter | Description |
|---|---|
| logical_ list | A list of conditions separated by commas. You can include
as many as 30 conditions in the list. 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