Skip to main content

LCM

Definition of LCM:

Returns the least common multiple of one or more integers.

Sample Usage

LCM(A2:A5)

LCM(2,3,A4)

Syntax

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

  • value1 - The first value or range whose factors to consider in a calculation to find the least common multiple.

  • value2, ... - [ OPTIONAL ] - Additional values or ranges whose factors to consider to find the least common multiple.

Notes

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

See Also

GCD: Returns the greatest common divisor of one or more integers.

Step 1. To use the LCM Formula, start with the Excellentable you would like to edit.




Step 2. Then type the LCM formula into the cell you have chosen to display the outcome:




Step 3. Fill in the 2 values.




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
Alaska
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
Colorado
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
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
27

JavaScript errors detected

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

If this problem persists, please contact our support.