In this post you will lean about the *LCM function,* how to use in your excel spreadsheets.

## LCM Function in Excel

The function returns the Least Common Multiple (LCM) of integers.

**Syntax**

**=LCM(number 1, number 2,....)**

The syntax initially has two arguments

**number 1**– This holds the first number**number 2**– This holds the second number,*default value 1.*

The initial argument is required to perform the function whereas the next argument is optional as it has the default value **1**.

## How to use LCM Function in Excel?

- The function returns the smallest multiple which is common between two number or more numbers. The functions work on integers and decimal numbers.
**For example:**- LCM(2,4) the answer is 8 as 8 is the smallest common multiple of 4 and 2 and LCM(3,4,5) the answer is 60 as 60 is the smallest common multiple of 3, 4 and 5.

- To start enter the numbers in the cells of the excel sheet
- In a new cell enter the
**syntax**and highlight the cells to include them in the function.

- Press enter to display the answer.

- Use the fill handle to apply the function to the remaining data.

The examples below has more than **2 arguments**

## Additional Points:

- The function does not accept non – numeric values and returns
**#VALUE!** - And similarly the syntax does not accept negative values, as a result it returns
**#NUM!** - The first row data does not show error as there is one value which can be accepted in the syntax.

## Leave a Review