# AND

### Definition of AND:

Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.

### Sample Usage

`AND(A2 = "foo", A3 = "bar")`

`AND(TRUE,FALSE,TRUE)`

`AND(A1:A10,B1:B10)`

`AND(0,1,2,3)`

### Syntax

`AND(logical_expression1, [logical_expression2, ...])`

`logical_expression1`

- An expression or reference to a cell containing an expression that represents some logical value, i.e.`TRUE`

or`FALSE`

, or an expression that can be coerced to a logical value.`logical_expression2, ...`

-**[**OPTIONAL**]**- Additional expressions or references to cells containing expressions representing some logical values, i.e.`TRUE`

or`FALSE`

, or expressions that can be coerced to logical values.

### Notes

- The number 0 is logically false; all other numbers (including negative numbers) are logically true.

**Step 1. **To use the AND Formula, **start with the Excellentable you would like to edit.**

**Step 2. Then type the AND** **formula into the cell you have chosen to display the outcome:**

**Step 3. Fill in the 2 values- In this formula there are four possible cases.**

**logical1 = TRUE and logical2 = TRUE**

**logical1 = FALSE and logical2 = TRUE**

**logical1 = TRUE and logical2 = FALSE**

**logical1 = FALSE and logical2 = FALSE**

### By adding the values you would like to calculate, Excellentable generates the outcome:

### See Also

`OR`

: Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.

`NOT`

: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.