# LCM Excel Formula Zaheer Formulas ,

What is LCM Function in Microsoft Excel?

LCM stands for Least Common Multiple, so the LCM function in Microsoft Excel is used to calculate the least common multiple of a given set of numerical values. The formula of the function is:

LCM(number 1, number 2, …number n)

In this formula, the number arguments are the numerical values for which you want to compute the least common multiple.

• In MS Excel 2007 and later versions, the LCM function is available as a standard and has been eliminated from the Analysis ToolPak.
• In MS Excel 2003, you can only use this function if you have the Analysis ToolPak add-in enabled.
• The LCM function can also be used to sum up fractions having different denominators.
• The #VALUE! error value is returned by the function if any of the supplied arguments are non-numeric values.
• The #NUM! error value is returned if any of the supplied arguments are less than 1.
• The supplied number arguments are reduced to whole numbers if any of them is not an integer.
• You can only supply a maximum of 255 arguments.

Examples on How to Use the LCM Function in Microsoft Excel

• Here are some examples that will help you to learn more about the usage of the LCM function to compute for the least common multiple of the supplied number arguments.
• Let’s say that you want to calculate for the least common multiple of 1 and 5. The first thing you should do is to type in this formula in any cell where you want the result to display, =LCM(1, 5). The function will instantly return the result which is 5.
• If you want to compute for the least common multiple of 25, 10 and 15, you can use this formula, =LCM(25, 10, 15). The function will return the result which is 150.
• Enter this formula in any cell if you want to find the LCM of 12, 8 and 1, =LCM(12, 8, 1). The function will return the result which is 24.
• Finally, you can find the LCM of 2 and 7 by using this formula, =LCM(2, 7). The function will return the result which is 14.

The best way to learn the usage of the LCM function is to try working with the examples that were given above in your blank Excel spreadsheet.