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
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
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