Formulas > =LCM()

How To Use LCM() Function in Google Sheets


Returns the least common multiple of one or more integers.

Common questions about the LCM formula include:
1. What is the LCM formula?
2. What is the syntax of the LCM formula?
3. What data type are used as inputs for the LCM formula?
4. What type of output does the LCM formula provide?

The LCM formula can be used appropriately to calculate the least common multiple between two or more numbers. It can also be used to compile and compare LCM values for at least two groups.

The LCM formula can commonly be mistyped by omitting the parentheses and commas, typing =LMC instead of =LCM, and typing in wrong parameters or values.

Some common ways the LCM formula is used inappropriately include applying it to calculate the greatest common divisor or typing in poorly formatted parameters in the formula or wrong data types.

Common pitfalls when using the LCM Formula include forgetting to format the output for fractional values, mistyping the formula, and not entering enough parameters.

Common mistakes when using the LCM Formula include mistyping the formula, entering wrong parameters in the formula, or using incorrect data types.

Common misconceptions people might have with the LCM Formula include believing it can be used to calculate the greatest common divisor or that it requires exact parameters for the calculation to be accurate.

How To Actually Use LCM() in Sheets

LCM(value1, value2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the LCM() formula:

Lcm function example in excel

This video shows you how to get least common multiple using lcm formula in MS Excel 2019 Office 365.

Generate a LCM() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.