Excel LCM Function

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

  1. Click on an empty cell (like F5 )
empty cell in excel

2. Click on fx icon (or press shift+F3)

fx icon in excel

3. In the insert function tab you will see all functions

 insert function tab in excel

4. Select math and trig category

5. Select LCM function

6. Then select ok

 LCM function in excel

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

How to use LCM function in excel

Examples of LCM function in Excel

Example 1:

How to use LCM function in excel

You can see examples of LCM function below:

Examples of LCM function in Excel
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  15

What 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)

Errors in LCM function

LCM related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *