How to Use the LCM function to determine the least common multiple
In this example, we will show you how to determine the least common multiple of two integers. Excel provides the LCM function through the Analysis ToolPak add-in. You will need to install and load the add-in to perform these steps. Here is the syntax that is used:
LCM(number1, number2, …)
number1, number2, …: From 1 to 29 values for which you want to find the least common multiple. Non-integer values are truncated.
To determine the least common multiple:
- In cells A2:A10 list any valid numbers.
- In cells B2:B10 list any valid numbers.
- Select cells C2:C10 and type the following formula: =LCM(A2,B2).
- Press Ctrl+Enter.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to use the GCD function to determine the greatest common divisor
- Use the MROUND function to round values to the nearest multiple of 10 or 50
- How to Use the SUMSQ function to determine the square sum
- How to Use the WEEKNUM function to determine the week number
- Use the EVEN and ODD functions to determine the nearest even/odd value
