Math and Trignometric - LCM Function
Advertisements
Description
The LCM function returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.
Syntax
LCM (number1, [number2] ...)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number1, number2... | 1 to 255 values for which you want the least common multiple. If value is not an integer, it is truncated. |
Number1 is Required. Subsequent numbers are Optional. |
Notes
- If any argument is nonnumeric, LCM returns the #VALUE! error value.
- If any argument is less than zero, LCM returns the #NUM! error value.
- If LCM (a, b) >=2^53, LCM returns the #NUM! error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements