LCM
Formulas / LCMCalculate the least common multiple of numbers.
=LCM(number1, [number2], ...)
- number1 - required, first number
- number2 - [optional], second number
Examples
The LCM of 25 and 40 is 200 because it is the smallest number that is a multiple of both 25 and 40. The LCM is calculated using the Sourcetable LCM function, which takes two or more numbers as arguments and returns their least common multiple.
The LCM of 3 and 4 is 12 because it is the smallest number that is a multiple of both 3 and 4. The LCM is calculated using the Sourcetable LCM function, which takes two or more numbers as arguments and returns their least common multiple.
The LCM of 3, 4, and 5 is 60 because it is the smallest number that is a multiple of 3, 4, and 5. The LCM is calculated using the Sourcetable LCM function, which takes two or more numbers as arguments and returns their least common multiple.
Need help with Formulas?
Summary
The LCM (Least Common Multiple) function is used to find the smallest positive integer that is a multiple of all the arguments. It can be used to add fractions with different denominators.
- The LCM function can take up to 255 arguments, which can be hardcoded constants, cell references, or ranges containing multiple values.
- The LCM function will return the least common multiple of all the numbers supplied, which is the smallest positive integer that is a multiple of all the numbers.
Frequently Asked Questions
What is the LCM function?
How is the LCM function used?
What is the purpose of the LCM function?
What are some examples of using the LCM function?
- If two fractions are 6/4 and 8/4, the LCM of 4 and 8 is 8. This can be used to reduce both fractions to 8/8 and 6/8, then add them together to get 14/8.
- If two fractions are 5/7 and 9/7, the LCM of 7 and 9 is 63. This can be used to reduce both fractions to 63/63 and 45/63, then add them together to get 108/63.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.