GCD

Definition of GCD

Returns the greatest common divisor of one or more integers.

Sample Usage

GCD(A2:A5)

GCD(24,96,A4)

Syntax

GCD(value1, [value2, ...])

value1 - The first value or range whose factors to consider in a calculation to find the greatest common divisor.
value2, ... - [ OPTIONAL ] - Additional values or ranges whose factors to consider to find the greatest common divisor.

Notes

Any input with a decimal part provided to GCD will be silently truncated.

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

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

Type in the complete GCD 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

1

	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