LCM

Calculates the smallest positive integer that is divisible by each of the given integers.

Parameter List

Syntax
LCM(number1
[number2, ...]
)
number1

The first integer. For example: 4, A1, or any numeric value.

[optional] number2, ...

Additional integers to find the LCM for. You can specify up to 255 numbers. For example: 6, 8, B1:B5.

More details

LCM accepts multiple integers and finds the smallest positive number that all of them divide evenly. All arguments are converted to integers by removing decimal portions. Negative numbers are treated as their absolute values. If any argument is 0, LCM returns 0. The result must be less than or equal to 9.99E+307, otherwise returns #NUM! error.

Examples

LCM(4, 6) returns 12