LCM Excel Formula

Author Zaheer    Category Formulas     Tags ,

Due to the rapid advancements in technology, tasks get even more complicated. And so with this, people need to cope with the increasing complexity of different tasks. So along with the rapid developments in the techno-world, a very useful software program was skillfully designed and created by the Microsoft Company, which is the Microsoft Excel. Excel incorporates lots of powerful functions and formulas that can help people to accomplish their tasks in a very quick and easy manner. This software program is widely used in different fields like business, science and engineering and especially in mathematics. Excel features several mathematical functions that have the ability to perform simple and complex calculations. One of these functions is the LCM function which computes for the least common multiple of a given set of numerical values. This article will provide you relevant information to help you learn about the LCM function. A good way to start with is to know the basic description of the LCM function, so read on…

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.

Remarks about the LCM Function

  • 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.

Post comment