Skip to main content

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)
2
50,645 (131,170)
1,775 (4,597)
7
3
570,641 (1,477,950)
94,743 (245,383)
1
4
113,594 (294,207)
396 (1,026)
9
5
52,035 (134,770)
1,143 (2,960)
4
6
155,779 (403,466)
7,916 (20,502)
53
7
103,642 (268,432)
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
540 (1,399)
1
10
53,625 (138,888)
12,133 (31,424)
27
11
57,513 (148,958)
1,912 (4,950)
14
12
6,423 (16,635)
4,509 (11,678)
2
13
82,643 (214,044)
926 (2,398)
2
14
15
G
1
2
TRUE
3
TRUE
4
TRUE
5
FALSE
6
TRUE
7
FALSE
8
TRUE
9
FALSE
10
TRUE
11
FALSE
12
TRUE
13
FALSE
14
15

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.