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.
How to use LCM Function in Excel?
  • Press enter to display the answer.
How to use LCM Function in Excel?
  • Use the fill handle to apply the function to the remaining data.
How to use LCM Function in Excel?

The examples below has more than 2 arguments

LCM Function in Excel
LCM Function in Excel

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.
LCM Function in Excel
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.