## 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 15

## What is the purpose of **LCM** function?

**LCM**

It Returns **the least common multiple**.

## What is the Return value of **LCM** function?

**LCM**

It returns a number.

## How many arguments does **LCM** function have?

**LCM**

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?

**LCM**

This function is available for all excel **versions **(2003-2019)