- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - LCM Function
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