# CHOOSE

### Definition of CHOOSE

Returns an element from a list of choices based on index.

### Sample Usage

`CHOOSE(2,"A","B","C")`

### Syntax

`CHOOSE(index, choice1, [choice2, ...])`

• `index` - Which choice (of the up to 30 provided) to return.

• If `index` is zero, negative, or greater than the number of choices provided, the `#VALUE!` error is returned.
• `choice1` - A potential value to return. Required. May be a reference to a cell or an individual value.

• `choice2, ...` - Additional values among which to choose.

`OFFSET`: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

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

Note : Here all the values can be a string, an integer or refernce to a cell

### By clicking on the cell you would like to calculate the CHOOSE formula for, Excellentable will generate 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
15
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
15
7

JavaScript errors detected

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