OR

Definition of OR

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

Sample Usage

OR(A2 = "foo", A3 = "bar")

OR(TRUE,FALSE,TRUE)

OR(A1:A10,B1:B10)

OR(0,1,2,3)

Syntax

OR(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.

See Also

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

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

In order to use the OR formula, start with your edited Excellentable

Then type in the OR Formula in the area you would like to display the outcome:

Type in the complete OR formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

	A	B	C
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	4833722	52,420 (135,767)
3	Alaska	735132	665,384 (1,723,337)
4	Arizona	6626624	113,990 (295,233)
5	Arkansas	2959373	53,179 (137,733)
6	California	38332521	163,695 (423,968)
7	Colorado	5268367	104,094 (269,602)
8	Connecticut	3596080	5,543 (14,356)
9	Delaware	925749	2,489 (6,446)
10	Florida	19552860	65,758 (170,312)
11	Georgia	9992167	59,425 (153,910)
12	Hawaii	1404054	10,932 (28,314)
13	Idaho	1612136	83,569 (216,443)
14
15		TRUE

	D	E	F
1

House seat(s)

50,645 (131,170)

1,775 (4,597)

7

570,641 (1,477,950)

94,743 (245,383)

1

113,594 (294,207)

396 (1,026)

9

52,035 (134,770)

1,143 (2,960)

4

155,779 (403,466)

7,916 (20,502)

53

103,642 (268,432)

452 (1,171)

7

4,842 (12,541)

701 (1,816)

5

1,949 (5,048)

540 (1,399)

1

53,625 (138,888)

12,133 (31,424)

27

57,513 (148,958)

1,912 (4,950)

14

6,423 (16,635)

4,509 (11,678)

2

82,643 (214,044)

926 (2,398)

2

TRUE

TRUE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE

TRUE

FALSE