What is LCM Function in Excel?
The LCM function is one of the math functions of Excel.
It Returns the least common multiple.
We can find this function in Math & trig category of insert function Tab.
How to use LCM function in excel
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select LCM function
6. Then select ok
7. In the function arguments Tab you will see LCM function
8 & 9. Numbers: number1,number2,… are 1 to 255 values for which you want the least common multiple
10. You will see results in the formula result section
Examples of LCM function in Excel
Example 1:
How to use LCM function in excel
You can see examples of LCM function below:
lcm(A2,B2) ----->>>>answer is 9
lcm(A3,B3) ----->>>>answer is 18
lcm(A4,B4) ----->>>>answer is 90
lcm(A5,B5) ----->>>>answer is 50
lcm(A6,B6) ----->>>>answer is 15What is the purpose of LCM function?
It Returns the least common multiple.
What is the Return value of LCM function?
It returns a number.
How many arguments does LCM function have?
This function has just 2 Argument.
The argument of LCM function is number.
Numbers: number1,number2,… are 1 to 255 values for which you want the least common multiple.
The argument of LCM function is required and not optional.
LCM(number) = number
Which version of excel supports LCM function?
This function is available for all excel versions (2003-2019)
