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.


Screen Shot 2016-05-27 at 9.26.25 AM.png


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


Screen Shot 2016-05-27 at 10.22.26 AM.png


Step 3. Fill in the 2 values.


Screen Shot 2016-05-27 at 10.23.22 AM.png


By adding the values you would like to calculate, Excellentable generates the outcome:

There were errors rendering macro:

  • An unknown error occurred.