LCM()
Syntax. LCM(number1,number2;...)
Definition. This 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.
Arguments
number1 (required) and number2 (optional) The minimum number of values is 1, and the maximum is 255 (29 in Excel 2003 and earlier versions) for which you want the least common multiple. At least one value is required but a second value makes sense so that a least common multiple can be found.
Background. For example, the least common multiple is used to add fractions. The least common multiple is the smallest integer that is a multiple of
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
