# LCM Function in Excel

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