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

Leave A Reply

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

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...