# 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 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:

A
B
C
D
1
State
 Population
Total area in mi2
Land area in mi2
Water area in mi2
House seat(s)
2
Alabama
4833722
52,420 (135,767)
50,645 (131,170)
3
735132
665,384 (1,723,337)
570,641 (1,477,950)
4
Arizona
6626624
113,990 (295,233)
113,594 (294,207)
5
Arkansas
2959373
53,179 (137,733)
52,035 (134,770)
6
California
38332521
163,695 (423,968)
155,779 (403,466)
7
5268367
104,094 (269,602)
103,642 (268,432)
8
Connecticut
3596080
5,543 (14,356)
4,842 (12,541)
9
Delaware
925749
2,489 (6,446)
1,949 (5,048)
10
Florida
19552860
65,758 (170,312)
53,625 (138,888)
11
Georgia
9992167
59,425 (153,910)
57,513 (148,958)
12
Hawaii
1404054
10,932 (28,314)
6,423 (16,635)
13
Idaho
1612136
83,569 (216,443)
82,643 (214,044)
14
TRUE
FALSE
E
F
1
2
1,775 (4,597)
7
3
94,743 (245,383)
1
4
396 (1,026)
9
5
1,143 (2,960)
4
6
7,916 (20,502)
53
7
452 (1,171)
7
8
701 (1,816)
5
9
540 (1,399)
1
10
12,133 (31,424)
27
11
1,912 (4,950)
14
12
4,509 (11,678)
2
13
926 (2,398)
2
14
FALSE
FALSE

`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`.