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.